What I am trying to do is to have a comparison of previous years data to the current years up to the current month (Data not available for future months). Using pivot charts and running total this produces a continuous flat line where data is not available in future months.
The Data is a large amount of transactions therefore a pivot chart will allow for changing the department or item. I have attached an example of the problem which I am trying to resolve. Currently I am selecting the points and formatting to remove them.
Any assistance would be greatly appreciated