5 Replies Latest reply: Feb 27, 2014 4:13 PM by whiteline _ RSS

    Specific sort order in multidimensional Pivot Table

    Iliyan Somlev


      Dear all,

       

      Could you take time to look at the following application. I have 2 vertical and 1 horizontal dimensions and I want to order my pivot table by the value of the first value of the horizontal dimension (KPI1). By writing the sort expression the first dimesnion is ordered correctly but not the second - you can see that for StoreID =1 Dec should be before Jan (as 56>51) but it is not!

       

      Similarly if I want to order by the values in KPI2 or KPI3.

       

      How can I make this sort order correct? I have to use a pivot as my app is much more complicated