Pivot Table Data

[gavindavey]

Hi all

I have created a pivot table that pulls data from a larger table. When you click on a field to pull back the data on a new worksheet it pulls all the data back from the original table.

Is it possible when you click on the pivot table to only bring back specific fields?

 

[Misca]

I don't think so:
Pivot tables are a "snapshot" of the data loaded in the cache when the data was refreshed. When you "pull back data" you're only getting the snapshot of those rows contributing to the number you double clicked.

There might be a way to use VBA to remove all the columns you don't want in your new worksheets but I don't think the pivot table itself could do that for you.

If you already know the rows you only want to show to the user I'd suggest you rearrange your data before creating the pivot table. This way those columns will be in the same order when the data gets "pulled back". This way the end users would still get to see all the columns from the original data set but the columns you're thinking they'd be mostly interested in would be easy to find.