Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
IF(Aggr(Rank(SUM([Qty of Sales]),4),[Sales Point]<=5,[Sales Point])
Tick Suppress When Value is Null
Expression
SUM([Qty of Sales])
Dear, thank you.
It's working