Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Modified qvw file showing the changes desired by you is attached.
Hope this helps.
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.
Bump!