Filter by Top 5 And Least 5 Performers

[DataPirate26]

Hi,

Below I have shared a dataset from where I need to Filter out the Top 5 or top 10 or top 15 etc and the Least 5,10,15 .... performers based on the Integration percentage. 

The Selection category should be dynamic that is it can be top 5, top 10, top 12 , top 13, top 15 as required by the user. Same for the least performers. Also need top place them in 2 separate tables and union them by and write the output in the same tab. 

below attached is the given Sample Input Data and the Desired output. Can someone help with this. 

[Qiu · Accepted solution]

@DataPirate26 
I use the Analytic App to allow to select the number. and hope you will not be to particular with the output format. 😁

[DataPirate26]

@Qiu perfect. thanx a lot for your quick response.

[Qiu]

@DataPirate26 
Thank you