PIVOT table linked with 2 formula columns

[viola38]

Hello, Quick issue with Pivots please!

I have Monthly sales data for 2014 and 2015 organized in PIVOT.
In this report, I want to present two particular columns. The columns would depend upon free selection (data validation or checkboxes).
So, if I select to view January 2015 data, then automatically the second column will display January 2014. if I select to view February 2015 data, then automatically the second column will display February 2014....and so on!

Whatever you select on the first column, gets compared with the Previous Year - same month data in the second column.

How to make this possible please??

[VKS]

Hello Viola,

Welcome to the Forum..

Depends how is your data structured but if you have Year and Month column in your data it easy if you dont have it then get the additional helper columns and you would not require data validation or check boxes drop take the just select the month in Filters and get year in the column area.

Hope this helps/VKS