Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Data behind Pivot Table
I have a source sending me reports in Excel Pivot Tables that I don't really
want. I need the raw data, and I keep getting Pivot Tables. I've been searching the help files for how to get the Pivot Tables off so I can see the data behind them, and I'll I'm finding is instructions on how to build a Pivot Table onto the data. I don't want the Pivot, I just want to see the data first to see what I'm working with. Can anyone tell me how to just turn all the fancy Pivoting off? The data's in there somewhere under all the buttons and drop down boxes, right? Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Data behind Pivot Table
See if this works. In the pivot table click on each pull-down and make sure
that nothing is deselected (i.e. all are set to "All"). Then double click on the grand total at the bottom right of the pivot table. A new tab should be created that shows the underlying data that contributes to the grand total (which should be everything if nothing is deselected). Will "Deadnskinny" wrote: I have a source sending me reports in Excel Pivot Tables that I don't really want. I need the raw data, and I keep getting Pivot Tables. I've been searching the help files for how to get the Pivot Tables off so I can see the data behind them, and I'll I'm finding is instructions on how to build a Pivot Table onto the data. I don't want the Pivot, I just want to see the data first to see what I'm working with. Can anyone tell me how to just turn all the fancy Pivoting off? The data's in there somewhere under all the buttons and drop down boxes, right? Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Data behind Pivot Table
AHA I knew it was something that easy. Thanks!
"roadkill" wrote: See if this works. In the pivot table click on each pull-down and make sure that nothing is deselected (i.e. all are set to "All"). Then double click on the grand total at the bottom right of the pivot table. A new tab should be created that shows the underlying data that contributes to the grand total (which should be everything if nothing is deselected). Will "Deadnskinny" wrote: I have a source sending me reports in Excel Pivot Tables that I don't really want. I need the raw data, and I keep getting Pivot Tables. I've been searching the help files for how to get the Pivot Tables off so I can see the data behind them, and I'll I'm finding is instructions on how to build a Pivot Table onto the data. I don't want the Pivot, I just want to see the data first to see what I'm working with. Can anyone tell me how to just turn all the fancy Pivoting off? The data's in there somewhere under all the buttons and drop down boxes, right? Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |