Jump to content
  • 0

Another Question On Pivot Table


Elena
 Share

Question

Hello there,

 

Is there a way to edit the label of the "value" side of the Pivot Table?

Right now, whatever I choose comes out in the table result.

 

For example: if I chose "Sum" from the drop-down of "Summarize value by:",  that word "Sum of" automatically show in my table results, along with the actual label that I type in.

 

If I chose "StdDev" the table results will show  "StdDev of". 

 

I don't like showing them automatically. Is there a way to get rid of this?

 

 

I attached a picture of what I meant, and a picture of my table, for reference.

 

Thank you.

post-16115-0-23044200-1454535846_thumb.j

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...