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.