Filter base on Top N

[dripet84]

Hi Everyone,

I have the following model and I need to find the 3 most company in a Group, base on the value of a particular KPI, (this filter should be dynamically in time), and for these 3 company (and the Group level if possible)  I should show all the other KPIs

https://drive.google.com/file/d/1TAetPxNFspnyM1plcsMojtvY7x4qALxB/view?usp=sharing 

Any idea how to make it?

Thanks

[dripet84]

This is what should i expect:

[dripet84]

I got N groups, each of them have N different companies.  Base on Ebit (which is the KPI), i need to find for each Group, the 3 Company which have the highest EBIT (and these should be in relation of time, Trim and year). Once I determining the Top 3 Companies of each groups, for particular Trim of particular Year, for this 3Top i should show the data of all the Scenarios (Actual, BDG, Forcast, act vs bdg ...) of others KPI (Ebitda, PL, cOST, and Deltas, including the EBIT). 

In the file i just reproduce the model i have, and how should i represent the data

(I put 2 Groups with 5 companies (in order to find  the top 3) , 2 year, 3 Trim, 4 indicators, 7 scenarios, 

[Ashish_Mathur]

Hi,

Your question is not clear.  In the file that you have shared, show the expected result very clearly.