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 the selection (data validation or checkboxes).
So, if they select January 2015, then automatically the second column will display January 2014.
Whatever you select on the first column, gets compared with the previous month data.
How to make this possible please??
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 the selection (data validation or checkboxes).
So, if they select January 2015, then automatically the second column will display January 2014.
Whatever you select on the first column, gets compared with the previous month data.
How to make this possible please??
