Hi,
I've created a pivot chart of 2017 and 2018 sales across four categories, by each 4 week period.
I needed to add a total to the pivot chart, and the simplest way I found to do that was inserting a calculated item of all 4 ranges and calling that the total. This adds a line which is effectively my grand total line.
The problem that this seems to cause is that my graph now counts through to period 12 and 13 of this year, which of course haven't happened yet. I can't exclude P12 and 13 from my data ranges as I need these included for 2017. I'm not sure why the graph does this only once I've added a calculated item. Does anyone have any suggestions, maybe a different way to go about this?
Thanks,
Gav
I've created a pivot chart of 2017 and 2018 sales across four categories, by each 4 week period.
I needed to add a total to the pivot chart, and the simplest way I found to do that was inserting a calculated item of all 4 ranges and calling that the total. This adds a line which is effectively my grand total line.
The problem that this seems to cause is that my graph now counts through to period 12 and 13 of this year, which of course haven't happened yet. I can't exclude P12 and 13 from my data ranges as I need these included for 2017. I'm not sure why the graph does this only once I've added a calculated item. Does anyone have any suggestions, maybe a different way to go about this?
Thanks,
Gav
