Indirect Top X Filtering & Custom Grouping/Sorting

[#1]

Hi all,

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.

[nagaiank]

Modified qvw file showing the changes desired by you is attached.

Hope this helps.

[#3]

Hi Krishna,

The desire result should only return 5 employees + Others. I want the list of Employees that serve the top 10 customer, and not the top 10 Employees. Hope this is clearer.

[#4]

Bump!