How do I filter displayed columns when double click in a pivot tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I double click in a field from a pivot table excel generates a new
worksheet with all rows containing the information I choose, but it also
includes all columns from the database to which the pivot table is refering
to. Is there a way to choose just the columns I need?

Excel version 2003
 
No, you can't control the output when you double-click on a pivot table
cell. You'll get all the columns from the source data.
 
Back
Top