View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rogbert rogbert is offline
external usenet poster
 
Posts: 1
Default 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