Is there a way to change the label for a dimension in pivot table in a macro vbscript ? I have the right syntax to change the label for an Expression in a pivot table :
set props = summaryTable.getProperties
set expr = props.Expressions.Item(0).Item(0).Data.ExpressionVisual
expr.Label.v = "Sales $(vCurrentYear)"
expr.NumAdjust = 1 'center
expr.LabelAdjust = 1 'center
summaryTable.SetProperties props
How can I adapt to change the label of a dimension ?