Can I permanently delete/hide data within Pivot Tables?

P

Peter

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!
 
E

Ed Ferrero

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Pivot Table Data Source to multiple ranges 1
Pivot table chart problem, How to show different subtotal levels 2
SUM & OFFSET & PIVOT TABLE?? 0
Multiple Tables and Multiple Pivot Tables Help 0
How I can set dynamic pivot table ONLY when I have enough data point 1
pivot table data 2
Drop Down Menu link to Pivot 0
Pivot table charting 3

Top