viola38
New member
- Joined
- Feb 2, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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 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 Year - same month data in the second column.
How to make this possible 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 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 Year - same month data in the second column.
How to make this possible please??