Subtotals: Nested subtotals below higher subtotal

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 Subtotals 3
description of count in subtotal 1
Subtotals 2
nested subtotals 1
Pivot Table Subtotals 1
Nested Subtotals 1
subtotals showing 0 in summary level// 2 subtotal levels 2
I need ONLY subtotals copied to a second sheet 4

Top