Indirect Top X Filtering & Custom Grouping/Sorting
I'm trying to create a table that will list the employees that handle the top 10 customers. I somehow manage to create the list using set analysis, but I have an additional requirement. I want to group those employees that are not handling the top 10 customers as "Others". So, the table should show the Employees that server the top 10 customer + "Others". And this "Others" will be at the bottom of the table.
I attached a sample QVW with some explanation inside.