I have attached the spreadsheet I am working on however, I am having issues in adding the monthly data to the existing summary.
The highlighted section in the data tab for July I need to add into the Pivot Table in Monthly Summary tab - as you can see, May and June are already in there and can be selected. Basically, I need to add July (and all subsequent months data) in this to be able to carry out a comparison.
Ive tried selecting the July data and adding to the data model, as well as creating a new pivot table as July however I cannot find where I can add the data into the current table in Monthly Summary tab.
This will be an on going process so I would be grateful for any advice you can give me to carry out this procedure as I've tried but having no luck.
For the pivot table you should only capture:
in five columns and let the pivot table do all the grouping and summing.