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:
- Rank Bottom - Net Pymt: RANK_UNIQUE(SUM([Net Payment]),'desc')
- Rank Top - Net Pymt: RANK_UNIQUE(SUM([Net Payment]),'asc')
- Rank Filter: [Rank Top - Net Pymt] <= [Top/bottom N :___]
OR
[Rank Bottom - Net Pymt] <= [Top/bottom N :___]
- Create a Parameter: (provided image)
Top/bottom N:
Data type: Integer
Current value: 5
Display format: Automatic
Allowable values: ‘All’
Happy Tableau-ing!