Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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"
Thank you very much.
Usefull tips