Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter base on Top N

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

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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, 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is what should i expect: