Rank function in calculated dimension

[Anonymous]

Good Day!

I'm making pivot table with dimesions and expressions described on the picture.

How can i use rank function in calculated dimension to select best 5 points of sales?

Many thanks for help!

[Gysbert_Wassenaar · Accepted solution]

Something like this: =aggr(if(rank(sum(Sales))<=5,[Sales Point]),[Sales Point])

Change Sales and Sales Point to reflect your real dimension names.

But try to use Dimension Limits instead. Those are less costly than calculated dimensions.

[MK_QSL]

IF(Aggr(Rank(SUM([Qty of Sales]),4),[Sales Point]<=5,[Sales Point])

Tick Suppress When Value is Null

Expression

SUM([Qty of Sales])

[Anonymous]

Dear, thank you.

It's working