0

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).

Image of what I'd like to achieve

4
  • You need to turn on subtotals for rows
    – PeterH
    Jun 11, 2019 at 13:54
  • I don't have time to write up an answer but this link will help contextures.com/excel-pivot-table-subtotals.html
    – PeterH
    Jun 11, 2019 at 13:55
  • Thanks @peterH. Turns out, turning subtotals on is in the "Design" tab.
    – Jochem PA
    Jun 11, 2019 at 14:10
  • when working with pivot table, I prefer to use tabular view when working with sub totals, Google how to use that you may find it useful also
    – PeterH
    Jun 11, 2019 at 14:18

0

You must log in to answer this question.

Browse other questions tagged .