troubleshooting Question

Adding additional data to a pivot table

Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
6 Comments1 Solution189 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Tom Farrar
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros