0 Replies Latest reply: Oct 24, 2017 8:15 PM by sandeep kumar RSS

    Pivot table suggestions required

    sandeep kumar

      Need to implement below in a pivot table. Not sure how to combine Multiple Dimensions and Measures.

      Connections and Disconnections below are measures.

       

      AUD 'Millions

       

      Prior Months

       

      Current Month

       

      YTD

       

      YoY %

       

       

      Jun-17

      Jul-17

      Aug-17

       

      Sep-17

      Sep-17 Budget

      Variance

       

      Sep

      Budget

      Variance

       

      Sep-16 v
      Sep-17

      YTD 16 v
      YTD 17

      Connections

      Disconnections