Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Adding additional data to a pivot table

Posted on 2016-07-21
6
Medium Priority
?
53 Views
Last Modified: 2016-07-25
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
0
Comment
Question by:Jase Alexander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 7

Expert Comment

by:tomfarrar
ID: 41723186
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.
0
 
LVL 7

Expert Comment

by:tomfarrar
ID: 41723265
Look at NewData tab in attached for what data and pivot table should look like.
EE_Example---Pivot.xlsx
0
 

Author Comment

by:Jase Alexander
ID: 41723313
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 7

Accepted Solution

by:
tomfarrar earned 2000 total points
ID: 41723458
Yes, that should work.  I made the raw data a table which the pivot table will adapt to the size as the (raw) data expands or detracts.  So yes, you should be able to add data to the end of the data, refresh the pivot table and the new results should be reflected.  If you want to make a data set a table, you can select a cell within the table and use the keystroke Ctrl/T.
0
 

Author Closing Comment

by:Jase Alexander
ID: 41727544
HI Tom

Thank you so much for the help - perfect !!
0
 
LVL 7

Expert Comment

by:tomfarrar
ID: 41727734
Glad to help.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question