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...
 
Top