Problem with nested subtotals, placing secondary subtotals BELOW .


G

Guest

I some but not all spreadsheets, my nested subtotal (slsperson) is placed
below the primary subtotal (branch). It has only happened to me since
upgrading to Excel 2003.

I sort by Branch, slsperson, customer. Then Primary subtotal is branch
(checks on replace current subtotals and summary below) and all is fine. Then
when I do subtotal on Slsperson it will place (above items unchecked) the
slsperson subtotal BELOW the branch. And also the levels (1,2,3) are not
displaying properly.

Does anyone have a suggestion for me?
 
Ad

Advertisements


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

Top