However, if we add a second field to the Row labels area, Product, we’ll see a subtotal for each category appear as a row in the table. Notice we see grand totals, but no subtotals. For example, in this pivot table, let’s add Category as a row label, and Region as a column label field, and Total Sales as a value.
When you first add Row or Column labels to a pivot table, you won’t see any subtotals.
However, you can turn subtotals on or off on a field-by-field basis. The default behavior for pivot tables is to automatically subtotal fields when they are added to row or column label areas.
