TOTAL<NO_TABLE_DIM> and AGGR

[cmorri1988]

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!

[sunny_talwar]

What is CT_KEY? You need to provide more details and preferably a sample to be able to help you better here

[cmorri1988]

Hi Sunny,

Please see example attached, CT_KEY replaced by 'GENRE'

Thanks

[cmorri1988]

example app.

[sunny_talwar]

Is this needed after a selection has been made?

[cmorri1988]

Yes, the selection generates results within the table, where this is required to show which selection generated which results.

Thanks

[sunny_talwar]

Have you tried this

Only(TOTAL BINDING)