Changing Pivot Table Header Name

[Zedrick13]

I can't seem to change my pivot table header name. What I usually do to do that is:

1. Click within the Pivot Table
2. Go to Analyze>Active Field Box>Change the name and;
3. Press Enter

I also tried:
1. Click within the column where I want the header to be changed.
2. Right click>Value Field Settings>Edit the name under Custom Name field.

Sadly, both methods did not work. Prior to doing the steps above, I just simply changed the value field from "Count" to "Sum".

[TABLE="width: 354"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD]Sum of Jan-16[/TD]
[TD]Sum of Feb-16[/TD]
[/TR]
[TR]
[TD]NSW 1[/TD]
[TD="align: right"]$123,220[/TD]
[TD="align: right"]$161,085[/TD]
[/TR]
[TR]
[TD]NSW 2[/TD]
[TD="align: right"]$35,605[/TD]
[TD="align: right"]$39,754[/TD]
[/TR]
[TR]
[TD]NSW 3[/TD]
[TD="align: right"]$122,717[/TD]
[TD="align: right"]$148,790[/TD]
[/TR]
[TR]
[TD]NSW 4[/TD]
[TD="align: right"]$166,746[/TD]
[TD="align: right"]$160,658[/TD]
[/TR]
[TR]
[TD]QLD[/TD]
[TD="align: right"]$53,592[/TD]
[TD="align: right"]$51,559[/TD]
[/TR]
[TR]
[TD]VIC[/TD]
[TD="align: right"]$26,552[/TD]
[TD="align: right"]$26,576[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$528,431[/TD]
[TD="align: right"]$588,421
[/TD]
[/TR]
</tbody>[/TABLE]

What I want to do is change the column header "Sum of Jan-16" to just "Jan-16".

Note: I am using MS Excel 2016

 

[Dolphinv4]

Was there a dialog box that says field name already exists?

If so, usually I'd just add a space in front or behind "Jan-16" in the pivot table.