ExcelBanter - how do I show grand totals for subtotals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I show grand totals for subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/226160-how-do-i-show-grand-totals-subtotals.html)

rogbert

how do I show grand totals for subtotals

I can get a Grand Total but would I would like is for the Grand Total to show
grand totals for the above Subtotals beneath it.

City 1 Total
Prod A subtotal
Prod B subtotal
City 2 Total
Prod A subtotal
Prod B subtotal
Grand Total
Prod A subtotal
Prod B subtotal

All times are GMT +1. The time now is 01:18 PM.