How to Make Range Name Label Appear in Pivot Table

[typewriterguy]

Hello spreadsheet gurus,

Can one of you help me to get my range name to appear as a column header in a pivot table?

I am trying to get a range name to appear as a column header in my pivot table, but the pivot table column header is instead showing a data value as the column header. My print requirements require that the range name label not appear in the source worksheet (as a column header or in the data).

Thank you.