Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning, I have the following problem:
I defined an expression in a chart that gives me the sum of certain amounts.
I would create a second term on the basis of the amount present in the first expression.
The result is correct, but if you want to see the partial sums of this second expression, I get 0 as a result.
Someone can help me ?
Thanks
If your using a straight table then set the Total mode of the expression to Sum of Rows. If it's a pivot table then use something like sum(aggr( ...original expression here ..., ...comma separated list of pivot table dimension names here... ))
ok but if I change the order of the column I obtain the total that I would.
It's strange ....
Why ???