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.

MESTRELLA29 wrote:
I think i did not make my self clear.

when i click to show the data, I dont want the columns to show.

"Debra Dalgleish" wrote:


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.

MESTRELLA29 wrote:

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?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html