Find my approach as reference below and stored in attached workbook version 9.3 located in the original thread
1. Define Rank: rank(sum([Sales]))
2. Drag Rank next to right of Sub-Category in the Rows-shelf and set it to Discrete
3. Set Rank to Compute using > Sub-Category
4. Filter Rank to the desired values
Rank option_nalmai.twbx 1.2 MB
Thankyou for this. This does indeed list the correct rows, however it still shows the total for the entire dataset, rather than the filtered ranked rows. How can I amend to total to reflect the filtered rows only?