Pivot Table

L

LionR1

I am working on a pivot table and I added the data field Sales. The sales
amounts appear in the data area, but Sum of Sales appear at the top left
portion of the table. How can I change that label to Julst Sales?

Also if I have multiple data fields how can I change those sum of fileds to
just the field name?
 
D

Debra Dalgleish

You can't use the same name as a field in the source data. However, you
could type Sales with a space character at the end, and that would be
accepted.
To change it, click on the cell with the heading, and type the new label.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top