View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RhysPieces
 
Posts: n/a
Default Pivot table subtotals

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.