2 Replies Latest reply: Jun 28, 2016 7:47 AM by Charlotte Gilbert RSS

    Pivot table: how to put 2 dimensions next to each other

    Charlotte Gilbert

      I've been asked to create this table:

       

      2015/16 2016/17 May-15 May-16

      Indicator

      Q 1 Q 2 Q 3 Q 4 Q 1 Q 2 Q 3 Q 4

      Sales

       

       

       

       

       

       

       

       

       

       

      Customers

       

       

       

       

       

       

       

       

       

       

       


      I've managed to create 2 separate pivot tables, one with year and quarter, and the other with month (with some calculations to only show the most recent month, and the same month for the previous year) but I'm not sure how I can have them both in the same object.

       

      Any help would be appreciated.