Macro to set name of pivot expression

[hugmarcel]

Hi

set chart = ActiveDocument.Activesheet.CreatePivotTable

chart.AddDimension "Product"

chart.AddDimension "ProductGroup"

chart.AddExpression "sum(Amount)"

set cp = chart.GetProperties

cp.TableProperties.PivotTableTotalPosition = 0   'top

chart.SetProperties cp

works fine. How to change the name of expression "sum(Amount)" to "Total Amount" in this pivot?

Thx - Marcel

[#2 · Accepted solution]

try this

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.Label.v = "Sales"

[hugmarcel]

http://community.qlik.com/message/150959#150959

explains it as well