Subtotals: Nested subtotals below higher subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem when using the automatic subtotal tool. I am
subtotaling twice, but on the second subtotal, some of the subtotals for the
second item are showing up below the subtotals for the first item. This
happens when there is only one second item for the first item. It then
affects all highest subtotals from then on.

For example:
Sports Football NFC
Sports Football AFC
Sports Total Count 2
Football Total Count 2

(rather than)
Sports Football NFC
Sports Football AFC
Football Total Count 2
Sports Total Count 2

Please advise if there's a workaround or if this is an Excel bug.

Thanks,
Rob
 

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

Nested subtotal display error 3
Nested Subtotals 3
Pivot Table Subtotals 1
Subtotal Function 5
Subtotals 2
How do I get the correct order for nested subtotals 1
How do i copy only the subtotals inserted into a list? 2
Problem with nested subtotals, placing secondary subtotals BELOW . 1

Back
Top