Pivot table subtotals

G

Guest

I have several worksheets with pivot tables that look alike. When setting
them up I generally have 5 levels of criteria to subtotal. On one of them I
noticed it only subtotals on the two highest levels. I compared it to the
others and checked all formulas and calculations but cannot see any
difference. How can I get this one pivot table to subtotal down to the fifth
level like the others? Thank you for any help.
 
S

steven1001

check that sub-totalling is enabled for the field.
..right click on field label, --> field setting --> subtotal =
automatic.
 

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

format pivot subtotals 2
Pivot Table Subtotals 1
Pivot Table subtotals 1
Pivot table subtotals 2
can i add subtotals to subtotals in a pivot table? 1
multiple subtotals in pivot table 1
Subtotals not working for Pivot Table 1
Pivot Table Default Setting 1

Top