Microsoft Office Tutorials and References
In Depth Information
Tip 82: Creating Pivot Tables with Multiple Groupings
Figure 82-2: Using a named range as the Table/Range.
You can use this trick with existing pivot tables. Make sure that you give the data source a different
name. Then select the pivot table and choose PivotTable Tools➜Analyze➜Data➜Change Data
Source. In the Change PivotTable Data Source dialog box, type the new name that you gave to the
range. This will cause Excel to create a new pivot cache for the pivot table.
Figure 82-3 shows two pivot tables (with different groupings) created from the same data source.
One pivot table is grouped by quarters and years, and the other is grouped by months and years.
Figure 82-3: These pivot tables were created from the same data source, but use different groupings.