Forum Stats

  • 3,851,925 Users
  • 2,264,053 Discussions
  • 7,904,906 Comments

Discussions

Need Help on Rank Formula:

Steelbird
Steelbird Member Posts: 34 Red Ribbon

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: