| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table-change Subtotal text?
I am running Offic 2000 under Windows NT. Is there a way to change the text
that gets displayed for subtotal lines? Current what gets displayed is <current value for field being subtotaled Total. Example: SS07-1300 Classic Comfort Trouser Total 21 Can I change it so it would just say 'Total for this category'? Thank you ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table-change Subtotal text?
You can type over one of the existing subtotal labels, and all the
subtotal labels for that field will change. Sue wrote: I am running Offic 2000 under Windows NT. Is there a way to change the text that gets displayed for subtotal lines? Current what gets displayed is <current value for field being subtotaled Total. Example: SS07-1300 Classic Comfort Trouser Total 21 Can I change it so it would just say 'Total for this category'? Thank you ! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table-change Subtotal text?
Thank you very much!
"Debra Dalgleish" wrote: You can type over one of the existing subtotal labels, and all the subtotal labels for that field will change. Sue wrote: I am running Offic 2000 under Windows NT. Is there a way to change the text that gets displayed for subtotal lines? Current what gets displayed is <current value for field being subtotaled Total. Example: SS07-1300 Classic Comfort Trouser Total 21 Can I change it so it would just say 'Total for this category'? Thank you ! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Pivot table text for totals & col headers? | Excel Worksheet Functions | |||
| pivot table : formula to absolute reference a subtotal | Excel Discussion (Misc queries) | |||
| Pivot table - Text in Data field | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Linear Mode
