ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table-change Subtotal text? (https://www.excelbanter.com/excel-discussion-misc-queries/88392-pivot-table-change-subtotal-text.html)

Sue

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 !



Debra Dalgleish

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


Sue

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