Secondary subtotals

D

Diane

I have a database I want to subtotal by both State and City. So for example,
I want to see subtotals for individual towns such Dallas, Houston, Cleveland
and Toledo, but then I want to see totals for Texas and Ohio.

I sorted first by State, then City and created subtotals for the sales
amounts based on the State. All is OK.

I created the secondary subtotal just like the first one except at each
change in City, and I told it not to replace subtotals. It doesn't look
right. Does any of this make sense? Any ideas what I'm doing wrong?

TIA
Dino
 
A

Anne Troy

Do it the other way around, Dino. Do the "lesser" grouping first (the one
that will group lesser records at a time), so do by City first, then by
State. You should be fine.
************
Anne Troy
www.OfficeArticles.com
 
D

Dino

Thanks Anne. I'm still not getting the correct results. I only have 3 levels
available, where I think I should have 4. Level 3 shows all detail and it
shows subtotals for City and then State, but the states are still separate.
I don't get a grand total for each state. See sample below ....

TACH LINA- RJM SEAL BEACH CA 5,764.16
345.85
SEAL BEACH Total 5,764.16
CA Total 5,764.16
TARRANCA DA LUGO SHERMAN OAKS CA 5,879.44
352.77
SHERMAN OAKS Total 5,879.44

CA Total 5,879.44

I need to see a total for all of CA. Other ideas?

Dino

--
 
D

Dino

Dave, That was it! Thank you soooo much. I made the registry indicated in
your link and it works exactly as I think it should.

Dino
 

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 in Excel 2003 9
multiple subtotals in pivot table 1
Excel Subtotals 1
sort subtotals? 1
Excel 2003: Conditional Formatting with Subtotals 1
Nested Subtotals 3
subtotals showing 0 in summary level// 2 subtotal levels 2
pivot table format 1

Top