How to Hide first Calculated dimension with pivot table

[Anonymous]

Hi Experts,

how to Hide first Dimension in Pivot table

[kaushiknsolanki]

Hi,

There is no default way to hide the dimension in Pivot table.

You can tell us what you want to achieve doing that.

Regards,

Kaushik Solanki

[Clever_Anjos]

Would you mind sharing a screenshot or a mockup of what you´re trying to do?

[Anonymous]

Hi Kaushik,

I tried to write in Macro that is working fine .

I am looking for UI and script level....below my macro code

sub Squeeze

call HideColumn("CH01", 1)

end sub

'

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub