![]() |
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 ! |
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 |
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 |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com