1 Reply Latest reply on May 30, 2013 6:55 AM by Robin Kennedy

    distinct top 10 businesses by sales across product lines

    Vincent Atwood

      How can I get distinct customers to show up accross top 10 product line sales?  If I do a top 10 against cust ID based on sum of Sales, I get the top 10 customers.  If i then drag in Prod_Seg (prod lines), I only get the # of same top 10 accounts for each product, for example 3 of the top 10 are in prod line 1, 5 are in prod line 2, 10 are in prod line 3, etc.

       

      How can I show the top ten business for each product line, not the total top ten and how many times they show up in each prod line?