Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I sum different assets for clients in Dimension using Sum function. I only need to present top 20, and I need grand total of that 20, but not total of al clients.
Tried using Sum of rows. does not work.
Any ideas?
You can use a set expression in your sum, something like
=sum( aggr(
if(rank(sum({<[Account.Type]={'Segregated'}>} [Ac.valuation]))<=20,
sum ({<[Account.Type]={'Segregated'}>} [Ac.valuation])
) , ClientDimensionField))
Stefan,
max points from me on all yours answers!!!
Thank you so much.
Asta