pivot table subtotals

  • Thread starter Thread starter dgknox
  • Start date Start date
D

dgknox

I'm stuck trying to develop subtotals in a pivot table. I hav
successfully placed Sums of the individual elements, but I'd like
"Subtotal" line for specific types of elements i.e.:
1/22 1/23 1/24
Group1 Apples
Oranges
Pears
Group1 Sum
Group2 Corn
Carrots
Beans
Group2 Sum
Grand Total

All of thee above rows/lines calculate just fine except the GroupX Su
lines?

Does anyone have any suggestions on how I can get subtotals to wor
correctly?

Do
 
Double-click on the field button at the top of the Group column.
Under Subtotals, choose Automatic, click OK
 
Back
Top