Requirement : Show the yearly sale by Sub-Category in ascending order.
As shown in the screen shot i have placed Year and Sub-Category in Rows and Sum of Sale in columns. I have also applied ascending sort on sub-category but still data is not sorted properly.
I have also created a hierarchy of Category and Sub-Category below.
Please tell me how can i get yearly sale by Sub-Category in ascending order.
Please follow the link: https://community.tableau.com/thread/151486
Hope that helps
You are not able to sort because Sub-categories repeat on different years and Tableau classify by total of all years.
I consider this a bug.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...