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

[vinieme12]

Not Possible

[vishsaggi]

May be you can try to squeeze that column using a Macro.

Ref From: Hide column in pivot table

Press Ctrl+M

Then copy paste this code

sub Squeeze

call HideColumn("CH01", 3)

end sub

'

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

[agni_gold]

Thanks,

But can we remove it without Macro ?

[vishsaggi]

Not possible. However, this is just a one time macro to run. Once you run this macro you can delete the macro and save it.

[agni_gold]

At the time of deployment should i need that macro also ?

means while publishing to browser ?

[vishsaggi]

Once you save it, it should be fine when you deploy to PROD.

[agni_gold]

and my table is pivot , and ad hoc reporting done on that , now when i am runnig this maro on my app , it is not removing that sqare , it is making closure my other columns

[vishsaggi]

Did not get you. In your pivot you sent you want 3rd column to be squeezed. So in your original pivot table you should figure out which column should be squeezed. Like change here:

3 here is like 3rd dimension column. If it is a 2nd or 4th column just replace 3 with that dimension order.

sub Squeeze

call HideColumn("CH01", 3)

end sub

'

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

[agni_gold]

Correct  , as i have already changed that , to my last column but i have done pivoting on that dimension , so that it is squeezing my data column not label , i want just to remove label, can you please share that file in which you have checked ?