how to Hide first Dimension in Pivot table
There is no default way to hide the dimension in Pivot table.
You can tell us what you want to achieve doing that.
I tried to write in Macro that is working fine .
I am looking for UI and script level....below my macro code
call HideColumn("CH01", 1)
private sub HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
Would you mind sharing a screenshot or a mockup of what you´re trying to do?
Retrieving data ...