I tried an extensive search of the forum and could not find anything that solves my problem.
I have attached a packaged workbook. Please only refer to the data in Sheet ''FD Q3/Q4 2018''.
Basically I have a calculated field calculating the difference between forecast data released from a previous month and a current month, for different brands. This difference was calculated using the ''Add table calculations'' option.
The difference is then plotted on a graph on the Rows, and the Brands are plotted in the columns.
Any help would be very much appreciated.
Just hide the previous month.