Grouping PivotTable changes the other pivot table

A

Adams12

Excel 2007 - I have a rank field going from 1, 1.1...5.9. I want to see
totals by the individual rank (1st pivot table) and then I also want to see
totals by grouping them i.e. all the 3's (2nd pivot table). If I make a
second pivot table and group it, it groups the data on the original as well.
I've checked the knowledge base, online, etc. Maybe I'm missing something
really obvious...
 

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

Top