Subtotals in Pivot Table

**Amarjeet Singh** · 02-15-2011, 12:04 PM

Hi, Is it possible to have the Subtotals at the end of the Pivot before Grand Total as in the attached sheet?

Thanks in advance.

**DonkeyOte** · 02-15-2011, 12:15 PM

No I don't believe so.

**MarvinP** · 02-15-2011, 12:23 PM

Hi -

I don't believe you can move all subtotals to the bottom, BUT you can get the same affect if you Collapse or Expand the "Expense Category". Witout showing the individual expenses all subtotals will be adjacent to each other with a grand total below that. Then you can click the "+" sign to expand an individual GPB or Expand all.

I hope that helps.