Skip to Main Content

Need Help on Rank Formula:

SteelbirdJul 25 2022 — edited Jul 25 2022

Hi Team, @Jerry Casey,
I have a data For Detail Report
image.pngI am creating Summary Report as follows
image.pngOn 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.