2 Replies Latest reply: Feb 22, 2013 11:32 AM by christian juillard RSS

    Aggr

    christian juillard

      Hi everybody,

       

      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?

       

      best regards

      chris