Partial sum of expression with if statement

[curiousfellow]

I have a pivot table with one dimension and an expression with an if statement.

when I summarize these expression values with partial sum I get wrong results.

Do I have to add something to my expression ?

[sunny_talwar · Accepted solution]

Is this what you want?

Sum(Aggr(if(source='x',sum(value_x),0)+if(source='y',sum(value_y),0), source))

[migueldelval]

Hi Curiousfellow,

Try this example, please and tell me if it´s your requirement.

Regards

Miguel del Valle

[curiousfellow]

This was not I was looking for, using Total gives wrong results.