Please find the attached workbook created using Tableau 9.0.4.
1. Create a Top 10 Client sets
2. Drag it to rows shelf
3. Drag the Client to the Rows Shelf
4, Add the Sales
5. Then Create %of Total using Table Calculation
6. Go to the Analytic pane and drag the subtotals
7. Create a region filter and add to to the Context.
Tableau Ranking Issue.twbx 30.5 KB
Thanks @Venu Babu Kolasani, this is helpful.
Is there any way to get the values that result from the IN set to act as a value for use in a related chart on another tab, essentially acting an interim calc?
For example, I'd be interested in creating either a bar or pie chart to show the impact of the top 10 as a percentage of the total amount; by 1 or more criteria that can be selected. (By Region and/or Project Manager) would yield a different chart. I hope I'm explaining it sufficiently enough. I envision the dashboard looking something like the quick mock up attached.
I can work thru the formatting of the charts; but just having trouble getting the underlying data I need a Dynamic Top Ten Revenue measure. I'm not even sure if it's possible.
Thanks for your help on this!
@Venu Babu Kolasani- it took some doing but I was finally able to get the views I needed using your template as a base. I needed to add some contextual filters to the view (that took some work to get straight!) but I'm good to go now. Thanks a million for your help!