I'm trying to use the 'rename summary label' option which appears when I right click on row value in a pivot table. But nothing happens... Screenshot below.

Instead of over-writing with 'Disability', all it does is move the '1' from the left of the cell to the right. Is this because summary label actually relates to total labels such as 'Grand Summary' which you could change to 'Grand Total' etc?

If so, I'm guessing there's no way of changing the '1' to display a different label without changing it in the raw data? 

Any ideas welcome!