Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.