Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping in Pivot Tables
Hi
Please help! I have a selection of data pulled down into a sheet using an ODBC connection. Great! I use this data to create different pivot tables in other worksheets (in the same workbook). However when I apply grouping levels on pivot table it applies to the other pivot tables in a different work sheet. It is so ANNOYING! Can anyone please tell me how I can prevent this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping in Pivot Tables
If you base other pivot tables on an existing pivot table, any grouping
will be applied to all the connected pivot tables. To prevent this you can create another pivot table based on the original source data. It will be independent of the other pivot tables, and won't be affected by any grouping. Bunji wrote: Hi Please help! I have a selection of data pulled down into a sheet using an ODBC connection. Great! I use this data to create different pivot tables in other worksheets (in the same workbook). However when I apply grouping levels on pivot table it applies to the other pivot tables in a different work sheet. It is so ANNOYING! Can anyone please tell me how I can prevent this? Thanks -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Grouping DAtes in Pivot Tables | Excel Discussion (Misc queries) | |||
grouping in pivot tables | Excel Discussion (Misc queries) | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Grouping Dates in Pivot tables | Excel Discussion (Misc queries) |