Max Rank Display

[Anonymous]

Hello,

I am attempting to display the ranking of sales per user.

Then I will later want to compare their sales figures to other users.

Please could someone explain how to rank the sales figures, to see the top 3 Users. Then display the top sales figures, so that we can later have a comparison to other Users and the top User, see attachment.

Thank you.

[lironbaram]

hi

have a look at the attach example

hope it helps you

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

User

Expression

SUM(Sales)

Num(Rank(SUM(Sales),4))

SUM(TOTAL {<User = {"=Rank(SUM(Sales),4)=1"}>}Sales)

If you want to compare top 3 with top then use as below

Straight Table

Dimension

User

Expression

SUM({<User = {"=Rank(SUM(Sales),4)<=3"}>}Sales)

NUM(Rank(SUM({<User = {"=Rank(SUM(Sales),4)<=3"}>}Sales),4))

SUM(TOTAL {<User = {"=Rank(SUM(Sales),4)=1"}>}Sales)