| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple subtotals
is there a way to subtotal at mutliple levels? for example:
dept rep account total fin me a 2 fin me b 3 hq you c 4 hq you d 5 hq you e 6 what i would like to do is have a subtotal for each change in dept, another subtotal grouping for each change in rep, and a final subtotal grouping for each change in account. is this possible? if it has to be done via vba, any ideas on what the code should look like? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple subtotals
Have you tried doing this in a Pivot Table?
See these links: http://www.contextures.com/xlPivot02.html http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan--- -- RyGuy "joemeshuggah" wrote: is there a way to subtotal at mutliple levels? for example: dept rep account total fin me a 2 fin me b 3 hq you c 4 hq you d 5 hq you e 6 what i would like to do is have a subtotal for each change in dept, another subtotal grouping for each change in rep, and a final subtotal grouping for each change in account. is this possible? if it has to be done via vba, any ideas on what the code should look like? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple column headings with Subtotals | Excel Discussion (Misc queries) | |||
| Subtotals from multiple columns? | Excel Discussion (Misc queries) | |||
| Selecting multiple columns for subtotals | Excel Discussion (Misc queries) | |||
| Subtotals multiple columns | Excel Worksheet Functions | |||
| Subtotals multiple columns | Excel Worksheet Functions | |||
Linear Mode
