PivotTable - Automatic Current vs Prior Month

[TheMacroNoob]

Hello excel experts,

In a PivotTable, are you able to have current/prior month in columns automatically/dynamically? Currently I have to select the months manually and move them in correct order.

Secondly, is it then possible to have variance in columns? See picture for example.

 

[awoohaw]

It would be a lot of help you would provide sample data that your pivot table is based upon.
Please use the xl2bb add in (link below) to do that. If you cannot use the add in then please paste your data as a table.
You're asking the forum to completely recreate your scenario. You'll get a quicker response, from a number of forum members if you do this.

Thanks in advance!