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.
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... ))