Solved

Adding additional data to a pivot table

Posted on 2016-07-21
6
23 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:spicecave
  • 4
  • 2
6 Comments
 
LVL 7

Expert Comment

by:tomfarrar
Comment Utility
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
Comment Utility
Look at NewData tab in attached for what data and pivot table should look like.
EE_Example---Pivot.xlsx
0
 

Author Comment

by:spicecave
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 7

Accepted Solution

by:
tomfarrar earned 500 total points
Comment Utility
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:spicecave
Comment Utility
HI Tom

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

Expert Comment

by:tomfarrar
Comment Utility
Glad to help.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now