This content has been marked as final. Show 2 replies
I'm using sum(aggr(sum(....))) for some expression in a pivot table.
One of the expression (GTP) is ([expr A] - sum(B))
Note Expr A uses already 3 others expressions that use sum(aggr(sum( )))
GTP is ok for everyline and the total use the same formula.
But for the total I just want a sum(GTP) and obviously i can't refer to [GTP] and the use of aggregate doesn't work. (I mean i didn't find the right solution).
Does anyone have a clue?