Tableau: How to rank top/bottom sales in Tableau?
Category:
Question ID: 109663
0
0

Hello — I would like to rank my top and bottom highest values for sales in Tableau.  Can you help me?

Thanks,

Rhonda

Marked as spam
Posted by (Questions: 13, Answers: 4)
Asked on July 15, 2020 9:29 am
146 views
Answers (1)
0
Private answer

Hi Rhonda,

I have used three (3) formulas from a 2015 and include a parameter to choose how many items to return.  This came from the 2015 post and it works great.

Create 3 fields:

  1. Rank Bottom - Net Pymt:   RANK_UNIQUE(SUM([Net Payment]),'desc')
  2. Rank Top - Net Pymt:   RANK_UNIQUE(SUM([Net Payment]),'asc')
  3. Rank Filter:    [Rank Top - Net Pymt] <= [Top/bottom N :___]

OR

[Rank Bottom - Net Pymt] <= [Top/bottom N :___]

  1. Create a Parameter: (provided image)

Top/bottom N:

Data type: Integer

Current value: 5

Display format: Automatic

Allowable values: ‘All’

Happy Tableau-ing!

Attachments:
Marked as spam
Posted by (Questions: 4, Answers: 14)
Answered on July 15, 2020 9:36 am
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top