Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
What is CT_KEY? You need to provide more details and preferably a sample to be able to help you better here
Hi Sunny,
Please see example attached, CT_KEY replaced by 'GENRE'
Thanks
example app.
Is this needed after a selection has been made?
Yes, the selection generates results within the table, where this is required to show which selection generated which results.
Thanks
Have you tried this
Only(TOTAL BINDING)