Secondary subtotals

[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

 

[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

 

[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

--

 

[Dave Peterson]

It doesn't look right is kind of vague, but maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;831824

 

[Anne Troy]

Dino: If you like, email your file and I'll have a look.
************
Anne Troy
www.OfficeArticles.com

 

[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

 

[Anne Troy]

Another article updated. Thanks, Dave.
http://www.officearticles.com/excel/getting_subtotals_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com