| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal show more columns
When you use subtotal the output is only 2 columns, what you subtotalled on
and your value or whatever you chose to calculate. How can I see other columns information as well on the subtotal line? I do realize the lines can be different but how would Excel handle this situation then? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal show more columns
Hi Mandy
Using Data - Sub totals should leave all your columns visible and just add sub totals to the column or columns you specify. Are you changing the Levels - ie 1,2,3 or hiding any columns? SallyT "Mandy" wrote: When you use subtotal the output is only 2 columns, what you subtotalled on and your value or whatever you chose to calculate. How can I see other columns information as well on the subtotal line? I do realize the lines can be different but how would Excel handle this situation then? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivottable: Show value as a percent of Subtotal | Excel Discussion (Misc queries) | |||
| subtotal on 2 columns | Excel Discussion (Misc queries) | |||
| why do the groups not show when i subtotal? | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Subtotal by two columns at once | Excel Discussion (Misc queries) | |||
Linear Mode
