Secondary subtotals
 

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

Secondary subtotals
 

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

"Diane" wrote in message
...
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

Secondary subtotals
 

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

--
"Anne Troy" wrote in message
...
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" wrote in message
...
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

Secondary subtotals
 

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...b;en-us;831824



Diane wrote:

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

--

Dave Peterson

Secondary subtotals
 

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

"Dino" wrote in message
...
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

--
"Anne Troy" wrote in message
...
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" wrote in message
...
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

Secondary subtotals
 

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


"Dave Peterson" wrote in message
...
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...b;en-us;831824



Diane wrote:

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

--

Dave Peterson

Secondary subtotals
 

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

"Dave Peterson" wrote in message
...
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...b;en-us;831824



Diane wrote:

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

--

Dave Peterson