How can I add a subtotal to an expanded field in a pivot table? (It shows fine when collapsed).
In the image below, I'd like to see "8" (6+2) in the highlighted cell (B2).
How can I add a subtotal to an expanded field in a pivot table? (It shows fine when collapsed).
In the image below, I'd like to see "8" (6+2) in the highlighted cell (B2).
subtotals
for rowssubtotals
on is in the "Design" tab.tabular view
when working with sub totals, Google how to use that you may find it useful also