Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Max Rank Display

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.

1 Solution

Accepted Solutions
MVP

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)

2 Replies
Partner - Master III

hi

have a look at the attach example

hope it helps you

MVP

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)

Community Browser