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?