If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to extract original data from a pivot table?
Hi,
I have an xls sheet that just has the pivot table but no data sources. I managed to extract data by double-clicking on a data field. If I make it so that there is one data field, I can extract all the data. However, there are a few fields in the pivot table field list that do not come up in the extracted data. So, I have two questions: 1. How do you create fields that are not represented in the base dataset? 2. How do you get the data from these fields? C. Magnus PS: I know a complicated way of extracting them--filtering the pivot table by each value of one of those fields, and then adding the field manually, then merging the data. I obviously don't want to go through this looooooooong loop. I have many data fields. |
#2
|
|||
|
|||
How to extract original data from a pivot table?
Your problem seems a bit strange because if the data is there your
should be able to access it by clicking on a suitable summary value. eg. to extract all the data doubleclick the Gross Total amount. You should also be able to access fields by clicking in the pivot table and using menu 'Data/Pivot Table Report' which opens the wizard with all the fields. Perhaps there are calculated fields ? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Refreshing pivot table when cut/paste data | Martha | New Users | 1 | July 2nd, 2004 02:57 AM |
pivot table data filter | pivot newbie | General Discussion | 2 | June 24th, 2004 06:58 PM |
Extract data from table to make a list of cell values | JoeBlow | Worksheet Functions | 3 | June 10th, 2004 07:42 AM |
scatter plots using pivot table data | Dan | Charts and Charting | 1 | June 10th, 2004 12:54 AM |