Pivot Table ?

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

Guest

I have a pivot table and when i double click to get the detail it brings me
all the coulumns from the source.

Is it posible to filter the column's in the detail, without deleting them
from the source?
 
You can filter or delete the detail data that's created when you
double-click on a pivot table cell. It won't affect the source data --
the detail data is just a copy of the source data.
 
I think i did not make my self clear.

when i click to show the data, I dont want the columns to show.
 
If Show Detail is used in a pivot table, all columns from the source
data will be shown.

Perhaps you could rearrange the source data, moving those columns you
don't want included to the far left or right of the source table. Then,
base the pivot table on columns that can be shown in the Show Detail
output.
 
You must log in or register to reply here.

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

One pivot table cannot overlap another pivot issue. 1
Referencing a pivot tables Grand Totals Column 1
date filter in a pivot table 1
Pivot Table Refresh 1
Pivot Table (column/row) label cache reset 4
Pivot from all sheets 1
pivot table data 2
Excel Pivot table - need to not remember old data which has been r 3

Back
Top