# 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

## 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 | 1 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

## 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

## 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

## 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