Change the Total Mode default settng by SetProperties

[#1]

set expr2 = cp.Expressions.Item(1).Item(0).Data.ExpressionVisual
expr2.Label.v = "UOM"
expr2.(**** need help for Total Mode default setting change *****)= 'No Totals'
set dims = cp.Dimensions
dims(0).Title.v = "CUSTOMER"
dims(1).Title.v = "LOCATION"
dims(2).Title.v = "ITEMNUMBER"

obj.SetProperties cp

I am trying to change the Total Mode setting in Straight Chart Properits to 'No Totals' instead of 'Expression Total' as default by macro. Could someone fill the third line mentioned above?

[Miguel_Angel_Baeyens]

Hello,

Instead of that third line, you will have to use something similar to this one

cp.Expressions.Item(1).Item(0).Data.ExpressionData.BrutalSum = false '' "No Totals"

Note that it's not a member of ExpressionVisual but ExpressionData.

Hope that helps.

[kji]

The setting you want is

 cp.Expressions.Item(1).Item(0).Data.ExpressionData. UsePartialSum = false

BrutalSum is to distinguish between the different ways to calculate the total ("Expression Total" and "Sum/Average... of Rows"

[#4]

Thank you very much.

[#5]

Usefull tips