Oracle Business Intelligence

Products Banner

Need Help on Rank Formula:

Received Response
6
Views
1
Comments

Hi Team, @Jerry Casey,

I have a data For Detail Report

I am creating Summary Report as follows

On Top customer Column Formulas:

I am using this formula:

CASE WHEN RANK(Dollars by Product) = 1 Then Customer Name End.

I am not getting correct Customer Name Values on Top1 Cust columns.

Can some one help on this ?

When I add the customer Name column on summary report It is giving proper results. The moment When I excluded the column It gives me wrong results.

Thanks,

Steel.

Tagged:

Answers