asked on

Adding additional data to a pivot table

HI Guys

Hope you can help

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.

Many Thanks
J
EE_Example.xlsx

Tom Farrar

The data model you are using is not conducive for a pivot table. The columns with dates should be in one column rather than multiple. Also the summations you are doing in the raw data should be done with the pivot table and not the raw data.

For the pivot table you should only capture:

Country
Mode
Product Group
Element
Date

in five columns and let the pivot table do all the grouping and summing.

Tom Farrar

Look at NewData tab in attached for what data and pivot table should look like.
EE_Example---Pivot.xlsx

Jase Alexander

ASKER

HI Tom

It looks amazing - thank you so much for your help

Just a question - to add data to the pivot table in New Data, do I just paste in the new weeks data at the end of the sheet in Data (2) and refresh in the New Data sheet?

J

ASKER CERTIFIED SOLUTION

Tom Farrar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jase Alexander

ASKER

HI Tom

Thank you so much for the help - perfect !!

Tom Farrar

Glad to help.