Here is updated file. Please refer Solution sheet. Used SUM(Sum Days) for Rank and placed it after Stage. Used the same for filter and selected 1 to 10. If you do not want to show Rank, then right click on SUM(Sum Days) pill and deselect Show Header.
Please check whether it helps you.
RFS - Official forum v.3.twbx 338.5 KB
Hi Claudia ,
Are you looking for this ?
So if I break this in to Steps
Technically we want to select only the Task having max (Sum Days)
So , let us create a Window_Max function
Then let us try a simple True or False condition where we want to select only if Sum(sum days ) = window_max (sum days) and ignore others
Plus ------>do remember how you move down along a specific dimension
Now just filter and set as True to get the desired result.
Please mark the answer as CORRECT & HELPFUL if it really helped you so that it can help others.
RFS - Official forum v.3.twbx 641.6 KB