1 Reply Latest reply on Aug 16, 2018 12:49 PM by Ritesh Bisht

    Filter "Create sets for Top N & Others"?

    George Nessim

      I created a worksheet following the exact steps in the tutorial linked below.



      I have a filter for sales person name. When I filter to a specific person it is only showing the Customer Names for individuals in the top 10 Overall and not the Top 10 for the specified sales person. I have seen some answers using INDEX that I do not really follow.

      Regardless, can I use a formula for the Top N Customers by Sales Parameter that calculates the Top N by "FIXED: Sales Person SUM(Sales)" or something of that nature?