6 Replies Latest reply: Sep 27, 2017 11:42 AM by Sunny Talwar RSS

    TOTAL<NO_TABLE_DIM> and AGGR

    Carmelle Morrison

      Hi there,

       

      I am required to use both the TOTAL qualifier and AGGR within one expression.

      The trouble is, I don't want to include CT_KEY as a dimension within my table, and am aware I need this for this expression to work.

       

      =sum(TOTAL<NO_TABLE_DIM> Aggr(ID,NO_TABLE_DIM))

       

      Does anyone know of another way to create this expression using AGGR only, so I am able to do this without using the TOTAL qualifier.

       

      Thanks!