Subtotal placement issue

S

simmerdown

I am running Excel 2003 SP3.

When calculating a subtotal on location, then by salesperson, excel is
inserting the subtotal for the salesperson after the location. I would
expect to see the following:

Salesperson 1 subtotal
Salesperson 2 subtotal
Location subtotal

What I am seeing is:

Location subtotal
Salesperson 2 subtotal
Salesperson 2 subtotal

Does anyone know why this is happening.
 
G

GaiGauci

Hi, without seeing a copy of your database, I wonder if you have sorted
first? First on location then salesperson.
 

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

Subtotal To Include Item Description On Subtotal Line 2
Sorting and subtotal in a filtered list 1
subtotal titles 1
Problem with subtotal function 0
SUBTOTAL function 3
subtotal not showing after filtering list 1
Macro Pause to Select range then Subtotal 0
Pivot Table Subtotals - Calculated field subtotal incorrect 3

Top