2 Replies Latest reply: Nov 14, 2014 4:26 PM by John Sakalis RSS

    Position

      Hello,

       

      I have pro year/ month the sales of specific cars e.g. opel, fiat, Mercedes etc.

       

      Now i want to have a pivot table

      with for the actual year the sells of cars and the position

      the previous year the sells of cars and the position within that year

      e.g.

                   2014               2013

                   sells position

      fiat        1000 1            fiat 800 3

      opel         800 2           Opel 900 1

      Mercedes  700 3        Mercedes  850 2

      you can see fiat 2014 position 1 2013 position 3

      opel 2014 position 2 2013 position 1

      Mercedes 2014 position 3 2013 position 2

       

      How to realise this?