Thank you very much for your reply on this - that definitely helps and splits these groups out. One final question is there a way to show just one tier at a time maintaining the % of total? Ideally on my viz I would like to show "% of Sales from Top 5" maintaining just the following data in my worksheet, but removing the other tiers turns the percentage of total to 100%. Somehow I need to fix the % but not sure how using sets!
Percentage of Total Orders
Top Tier (top 5 websites by orders rank DESC) 416 30.01%
Please find the attached w/mod on Sheet 7a
Done with a LOOKUP(..., 0) Table Calculation filter
and Aliasing the Top 5 In Value.
Orders by Ranked Group_YF.twbx 94.6 KB
Great thank you very much for this Yuri! That's exactly what I needed