Select columns when drilling into a Pivot Table
 

Hi All,

Can this be done? I want to drill into a pivot table but only show
certain columns from the underlying data when the new sheet is created.


For instance if I have Name, Address, City, State and Zip Code as the
data in the data set. If I drill into a number in the pivot table, I
only want to see Name and City instead of all of the data elements.

Thanks,

Select columns when drilling into a Pivot Table
 

You get what you get - which is all the elements.

It is showing your the underlying records/rows that make up that summary
cell.

--
regards,
Tom Ogilvy


" wrote:

Hi All,

Can this be done? I want to drill into a pivot table but only show
certain columns from the underlying data when the new sheet is created.


For instance if I have Name, Address, City, State and Zip Code as the
data in the data set. If I drill into a number in the pivot table, I
only want to see Name and City instead of all of the data elements.

Thanks,