Why does my pivot table label disappear when pivoting ?

[#1]

Hi,

I have a pivot table comprising a single dimension of Year-Month which has been pivoted to display horizontally. The expression is displayed as a percentage, like this...

However, you will notice the expression label doesn't display even though I have it set thus...

Any ideas why the label doesn't show ?

MV

[Chanty4u]

create with  empty space   as dimension

[#3]

Thanks for that. It's not perfect but at least it displays the first expression label.

[Chanty4u]

Hiding Dimensions in Pivot Table

[#5]

Ah yes. This is the best solution. This works. Thanks to everyone who contributed to my understanding.

MV