Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Need Help on Rank Formula:

Received Response
5
Views
1
Comments
Steelbird
Steelbird ✭✭✭
edited August 13 in Oracle Analytics Cloud and Server

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

  • Jerry Casey
    Jerry Casey ✭✭✭✭✭

    Hi @Steelbird ,

    Sorry - I'm rarely on here now. If you still need this, leave the customer name in the data, and use a pivot table for your summary. Set the agg rule to max on your rank columns.

    Data, using your formulas, with pivot table below: