3 Replies Latest reply: Jun 23, 2011 8:55 PM by Khim Hoe Tan RSS

    Indirect Top X Filtering & Custom Grouping/Sorting

      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.