This content has been marked as final. Show 2 replies
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.