Pivot Table-change Subtotal text?

S

Sue

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 !
 
D

Debra Dalgleish

You can type over one of the existing subtotal labels, and all the
subtotal labels for that field will change.
 
Top