Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I permanently delete/hide data within Pivot Tables?
Microsoft Excel 2002
I have 155 clients which I need to run Pivot Tables for! All with the same pivot table layout. Is it possible to run the Pivot table with the 155 clients as a Template basically, then somehow delete or permanently hide the data leaving only one client, so that I can save multiple copies for each of the individual clients? Or can I set up a pivot table where I can automatically feed in parameters? Client details are stored on an Oracle database! |
#2
|
|||
|
|||
Hi Peter,
Right-click on a Page Field and select Field Settings from the context menu, then click the Advanced button. You can then choose to query the external data source as you select the page item. So, if the client is a page field, selecting one client retrieves data for only that client. Ed Ferrero http://edferrero.m6.net Microsoft Excel 2002 I have 155 clients which I need to run Pivot Tables for! All with the same pivot table layout. Is it possible to run the Pivot table with the 155 clients as a Template basically, then somehow delete or permanently hide the data leaving only one client, so that I can save multiple copies for each of the individual clients? Or can I set up a pivot table where I can automatically feed in parameters? Client details are stored on an Oracle database! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to clear data references in pivot table report | Charts and Charting in Excel | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot table of data in more than one worksheet | Excel Discussion (Misc queries) | |||
Need Formula to display pivot table source data | Excel Worksheet Functions |