Help with TOP Rank Table

[antoniodneto]

Hi guys

I have 3 dimensions. DATE, CLIENT and CODE with 3 measures: SALES, COST and PROFIT.

I need to show the TOP 20 CLIENTS using MAX DATE. How can I achieve that?

Tks a lot!

[Lisa_P]

Have your CLIENT as the dimension, use Max(Date) as the first measure in the table and in the CLIENT dimension, in the properties panel, set the Limitation to Top 20, deselect Show others.

[puneetagarwal · Accepted solution]

Hi,

Please try the below expression and change the field-names accordingly

if( aggr( rank(Sum(Sales)),Client) <=20,Client)

Regards,
Puneet Agarwal