Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Remove 'Sum of' (2003, SP2)

    I *thought* I once saw that it was possible to change a pivot table setting so that Data fields are shown without a "Sum of" prefix. Does anybody know if that's possible? I realise that the displayed name can be changed after the fact - I currently programatically change all occurrences of "Sum of" to "" (leaving a space in front so that the new name is unique). That works fine, but if the user drags an extra pivotfield into the Data area it will be displayed with the "Sum of" prefix.
    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove 'Sum of' (2003, SP2)

    Already asked in <post:=693,726>post 693,726</post:>. Please don't post the same question twice.

    This thread is locked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •