Category Archives: Group and Total

GetPivotData Problems With Subtotals

To pull data from a cell in a pivot table, you can use a normal cell reference, such as =B5, or you can use the GetPivotData function, which is specially designed to extract data from a pivot table. The advantage … Continue reading

Posted in Group and Total | Leave a comment

Show Multiple Grand Totals in an Excel Pivot Table

In a pivot table, you can show multiple subtotals for a field, such as Sum, Count and Average. However, there isn’t a setting that lets you show multiple Grand Totals. With a simple workaround, you can replace the Grand Total … Continue reading

Posted in Group and Total | 5 Comments

Count Blank Entries in Pivot Table

It’s easy to count things with a pivot table – just drop a field into the pivot table’s Values area, and change the summary function to count. Sometimes you don’t even need to change the function to Count – it … Continue reading

Posted in Group and Total | Leave a comment

Group Pivot Table Numbers by Tens

Instead of showing a long list of items in a pivot table, you can group dates or numbers, and even text, to create a shorter list. In this example, the units have been grouped by tens, so there are only … Continue reading

Posted in Group and Total | Leave a comment

Show Subtotals at Bottom of Pivot Field

When you add fields to the Row Labels area of a new pivot table, subtotals are automatically shown at the top of each group of items, for the outer fields. You can turn the subtotals off, or move them to … Continue reading

Posted in Group and Total | Leave a comment

Grouped and Ungrouped Dates from Same Pivot Table Source

In some workbooks, you might create two or more pivot tables that are based source data. Even if they are on different worksheets, those pivot tables will share some features, such as calculated items and grouped fields.   So, if … Continue reading

Posted in Group and Total | Leave a comment

Change Excel Pivot Table Subtotal Text

When you add two or more fields to the Row area in a pivot table, the outer fields will automatically display subtotals. By default, the subtotal row has a label that stars with the item name, followed by "Total" In … Continue reading

Posted in Group and Total | 2 Comments

Pivot Table Grand Totals at Top

When you create an Excel pivot table, the grand totals are automatically added at the bottom, and at the right. With the Grand Total command on the Excel Ribbon, you can show or hide the grand totals, but you can’t … Continue reading

Posted in Group and Total | Leave a comment

Quickly Remove Pivot Table Grand Totals

You probably know how easy it is to add or remove the Grand Totals in a pivot table, by using the Ribbon commands. But keep reading, to see an even quicker way! Grand Totals on the Ribbon Yes, it’s easy … Continue reading

Posted in Group and Total | Leave a comment

Pivot Table Grouping Affects Another Pivot Table

In Excel 2007, when you create a second pivot table from the same source data, you don’t get an option to base the new pivot table on an existing pivot table, the way you can in Excel 2003. In Step … Continue reading

Posted in Group and Total | 12 Comments