Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Black_Hole
Creator II
Creator II

Chart Properties : Total Mode

Hello all,

I have an expression in my table box.

I checked the following box in order to display the  total sum on the head of the column with expression.

ChartProperties.PNG

But, the value calculated is not correct.

Please could you confirm that I checked the correct box.

The purpose is to have the total sum of the column with expression.

Thank you in advance for your help.

Labels (1)
1 Reply
gavinlaird
Contributor III
Contributor III

Could you please paste your expression?

Checking "Expression Total" under Total Mode, rather than "Sum of Rows" will calculate the total once across all dimensions. With "Sum of Rows" mode, the chart will calculate a separate "AmountCalculated" value for each combination of dimensions, then sum up those values.