How to rename fields in a pivot table

However, you might manually change the name to almost anything you like.

Lets take a look.

Here we have a blank pivot table.

Lets add the product field as a row label and the total sales field as a value.

Notice that value fields are automatically renamed to show the pop in of calculation being used on the field.

In this case, we get Sum of Total Sales.

If we change the calculation to Count, the field is automatically renamed to Count of Total Sales.

However, we can rename the field as we like.

For example, we can rename this field to Sales.

Visually, the field looks the same, and Excel wont complain about duplicate field names.

When you rename field names, you may want to confirm the original name from the source data.

you’ve got the option to do this by accessing Field configs for the field in question.

Here, you could see the original field name.

In fact, they are linked, as well see in a minute.

Youre free to bang out over the name directly in the pivot table.

you’re able to also use the Field parameters dialog box to rename the field.

When you rename fields used in Columns or Rows, the name also changes in the field list.

To go back to the original name, re-enter the field name manually.

Alternately, you’re free to dump the pivot table and start again.