Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum of Top N


Hi all

I have two dimensions (Portfolio and SecurityCode) and one field (MarketValue), and would like to show the sum of the top 10 securities (by percentage of each portfolio) for each of the portfolios i.e. each portfolio could have a different top 10 (and probably will).

I have attached a sample model. Any help will be appreciated.

Thanks.

Joao

2 Replies
tresesco
MVP
MVP

May be like attached sample?

CELAMBARASAN
Partner - Champion
Partner - Champion

PFA - using Straight table and Dimension limits.