Select columns when drilling into a Pivot Table

  • Thread starter Thread starter Smythe32
  • Start date Start date
S

Smythe32

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,
 
You get what you get - which is all the elements.

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