|
Pivot Table ?
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. 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 |
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 |
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 |
| All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com