Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like attached sample?
PFA - using Straight table and Dimension limits.