Pivot table suggestions required

[Anonymous]

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