Pb with total aggr

[#1]

Hi everybody,

i'm looking for a solution to this problem.

Let say i've a formula like GTP = (A * B - C ) -D where A,B,C,D are expressions using sum(aggr(sum( ))).

It works perfectly for every line and total but there is a special rule for GTP total which has to be like sum(GTP).

here is a sample.

I will appriciate every clue because i tried i think almost everything (dimensionality, above(aggr....)

[danielrozental]

Sorry, I don't understand the problem. What Expression is returning the wrong value? what value are you expecting to get?

[#3]

Hi Daniel

in the pivot table there is a column named GTP.

This column gets a result from other columns which is correct for every line but for the GTP total i need sum(GTP) and i can't work it out.

I hope this is more clear

best regards

christian