| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Secondary Axis | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Linear Mode
