View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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