Wrong total with Aggr

[#1]

Hi everybody,

I'm using sum(aggr(sum(field))) in 4 expressions. It works perfectly for every line and total.

But I've another expr T which uses the 4 expressions like (A * B - C) * D

So T is correct for every  line but for the total *I would like T equals some of evryline and I can't refer to expression.

Thank you for your help

Chris

[Gysbert_Wassenaar]

If you're using a straight table you change the Total Mode of the expression from Expression Total to Sum of Rows.

[#3]

Hi Gysbert,

unfortunately i'm using a pivot table.

And , before you ask, use of dimensionality() has no effect because my pb is to use the right formula

Chris