2 Replies Latest reply on Sep 30, 2016 5:21 AM by Luciano Vasconcelos

    Having some problem in sorting the data

    Umar Sattar

      Yearly Sale and Sub-Category.PNG

      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.