Categories
- All Categories
- 141 Oracle Analytics News
- 26 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 52 Oracle Analytics Trainings
- 11 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need Help on Rank Formula:
Steelbird
Rank 4 - Community Specialist
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:
0
Answers
-
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:
0