View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duncan Sibbald
 
Posts: n/a
Default Subtotals at different levels in nested table

I have created a series of subtotals which are at different levels, 1,2 and
3. Up until now I have been subtotalling fine and the left hand side allows
me to collapse and expand perfectly. I am working on level 2 subtotals and
suddenly I have tried to subtotal a new set of figures and it is making them
level 3 whilst there is no level 2.

Can anyone help ?

Thanks in advance,

DS