pivot table subtotals

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
 
D

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple subtotals in pivot table 1
can i add subtotals to subtotals in a pivot table? 1
Pivot Table Subtotals 1
Pivot Table subtotals 1
Subtotals not working for Pivot Table 1
Can i hide parts of a Pivot tables subtotals??? 2
Excel 2002 Pivot Tables 1
Place all subtotals at bottom of pivot table? 2

Top