Pivot Table group levels

[Bunji]

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

 

[Roger Govier]

Hi

When you create your PT's you are using the same Pivot cache for each of
them, hence you will see this behaviour.

If you choose the option not to use an existing data set (to save space)
when creating subsequent PT's, each will have its own cache and any
groupings will be independent.

 

[Bunji]

Hi Roger

Thank you for the reply but I dont see the setting that you mention.

I am using Excel 2007 and when I am on the data source I click insert pivot
table
I am then presented with the box that ask me to select a table or range
Then where I would like the pivot table to be placed... into an new
worksheet.

So if you could divulge a little more I would be most grateful.

Thanks

 

[Roger Govier]

Hi

OK, a little different with 2007.
First create a Table, by clicking anywhere in your Source and choose Insert
tab>Table (NOT Pivot Table)
It will probably be called Table 1, but you can rename it to whatever you
want.
Click on the Table created>Select Design tab>Summarize with Pivot Table
Make your selections to the various areas etc.

Click on the table again>Design tab>Summarise with Pivot Table
Set it up as you wish.

Each will have it's own cache, even though it is based upon the same source
table and any Grouping etc. will be independent.

I suspect you created your Multiple PT's by selecting your Source>Insert
tab>Pivot Table and repeated this many times.
This would use the same pivot cache for all tables.