Remove pivoting dimension header label.

[agni_gold]

Hi Friends,

I have one situation,

I have one pivot table and also done pivoting over year dimension and made its label as blank, not I don't want that small square which is coming below in screenshot,

Any help

as it is ad-hoc reporting so that I cannot put a text box over it ., Attaching sample file

[vishsaggi]

This is your actual qvw file i worked on. See attached.

[agni_gold]

But when i send it to excel but column C is still there .

[vishsaggi]

Thats what we said it is not possible to completely remove it because in your pivot you are using field Year which displays 2013, 2014 etc. So when you export to excel the column C will be suppressed mode. You can just delete that column once you export to excel as an alternative.