Top N selection on Ranks

[insandur]

I have a table with below columns and created a dyanmic measure "Rank" on savings and now i want to have option as TOP 3,5,7,10 ideas as filter options  based on Rank and it should be dyanimc when i use filters on  "Function" column.

Ideas	Savings	Function	Rank
A9	95070	Travel	1
A4	81900	IT	2
B7	81174	Commercial	3
A1	80422	Education	4
A7	52209	Travel	5
B6	48892	Education	6
A10	44861	Commercial	7
B5	36907	Education	8
A5	35886	Travel	9
A8	32030	IT	10
A2	25838	Commercial	11
A3	9055	Travel	12

[wdx223_Daniel · Accepted solution]

hope this can help