1 of 1 people found this helpful
Tableau sort always sorts specific to the lowest nested dimension - in this case it is sorting just [Site] by the overall Total Cost (regardless of the cost center it belongs to). In order to make each site distinct for each cost center, you might used a combined field to help show the unique combination and sort based on this new dimension.
This video might help illustrate how to work through this issue: Tableau Advanced Sorting - YouTube
Hi Brett Sim
I have attached a packaged workbook using sample superstore data store. You will need to create a calculated field called [Index].
Here is the mapping between your fields and mine
Type of Cost - Category
Cost Category - SubCategory
Site - Region
Total Cost - Sales
Only additional field I have is Index. Right click on Index and click on Edit Calculation to understand the table calculation setup. You need to apply similar calculation using your fields. Make sure you maintain the order. Once you are done, right click on Index and un-check "Show Header"
If you have more questions please let me know.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
726035.twbx 1.2 MB
Thank you both for great, quick replies! Both very helpful and I learned a lot! This forum rocks!