Total Row

[#1]

Hi, in the attached example, I don´t know how to get the correct Total Value for the Final Balance column, as you can see the Total row is not showing the correct value of the detail sum that should be 210.

Any idea of how can I get it?

[sunny_talwar]

Try the attached

[#3]

Great, now taking one step further, if I add a extra dimesion  how could I get the same result

[agustinbobba]

Try this!, on the chart properties

Best regard!

Agustin

[sunny_talwar]

Add a dimension? Not sure I understand? Which table are we wanting to fix? the top one or the bottom one and which expression?

[sunny_talwar · Accepted solution]

May be this?

Sum(Aggr(if(aggr(sum(Forecast),Cod_prod)*vCost >aggr(sum(Balance),Cod_prod),sum(Balance),sum(Forecast)*vCost), Region, Cod_prod))

[#7]

Thanks, that's exactly what I want