how to Sum Top clients by assets

[Anonymous]

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?

[swuehl]

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))

[Anonymous]

Stefan,

max points from me on all yours answers!!!

Thank you so much.

Asta