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.
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.
Question
Elena
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.
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.