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.
 

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

Pivot table filter list - listing irrelevant subcategorys 1
Single Filter to change all Pivot Tables in a Workbook 8
about pivot table 1
date filter in a pivot table 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table - 3
Derived Columns in Pivot Table 1
Access #Error & Excel Pivot 0

Back
Top