Hi,
I have a pivot table that displays the sales per region month by month.
For any given period I want to be able to compare the YTD sales figures with the YTD figures for the same period in the previous year.
I have managed to create a second column displaying YTD sales next to the period sales. By filtering for period 1-3 for example i then get period 1-3 and the respective YTD figure. Since the YTD figure is really just the running total of all months displayed, this doesn't really do the trick. Is there another way around this problem?
I want to display at the ned of period 3:
.......................................YTD 2012 (period 1-3) | YTD 2013 (period 1-3)
North
East
West
Thanks a lot for your help in advance,
Nils
I have a pivot table that displays the sales per region month by month.
For any given period I want to be able to compare the YTD sales figures with the YTD figures for the same period in the previous year.
I have managed to create a second column displaying YTD sales next to the period sales. By filtering for period 1-3 for example i then get period 1-3 and the respective YTD figure. Since the YTD figure is really just the running total of all months displayed, this doesn't really do the trick. Is there another way around this problem?
I want to display at the ned of period 3:
.......................................YTD 2012 (period 1-3) | YTD 2013 (period 1-3)
North
East
West
Thanks a lot for your help in advance,
Nils