5 Replies Latest reply: Aug 13, 2014 6:21 AM by Eric Tay RSS

    Sorting in Pivot Table

    Eric Tay


      Dear all,

       

      Notice that when we sort using expression in Pivot Table, sometime the sorting is incorrect.

       

      In below example, I would like to sort the Year, Division and Category dimensions using Sum(LineSalesAmount).  When I expand the Division column, notice that the Sum(LineSalesAmount) for Year 2012 are not sorted properly, as shown below:

      Image1.png

       

      When I expand the Division and Category columns, notice that the Sum(LineSalesAmount) are not sorted properly, as shown below:

       

      Image2.png

       

      Below is my sorting tab:

       

      image3.png

       

      Any tips how to sort the Year, Division and Category dimensions using sum(LineSalesAmount) correctly?

       

      Regards,

       

      Eric