10 Replies Latest reply: Nov 24, 2014 5:34 AM by André Gomes RSS

    Sort Pivot Table

      Hello,

       

      I have a pivot table

      Year against cars giving calculated value number of sales.

      Now i can sort year and the cars but not the calculate value number of sales

      is this possible and how can i sort?

       


      e.g

                                2014    2013

      fiat                       200    150

      opel                     300     125

      Mazda                 500   100

       

      Now i want to sort

       

                              2014 2013

      Mazda              500    100

      opel                 300     125

      fiat                   200      150