5 Replies Latest reply on Oct 7, 2013 12:55 PM by Matt Lutton

    Show the number of sub-categories that have at least x amount of sales

    David Drees

      I have what seems to be a simple calculation, but I'm not getting the answers I need.  I have Categories of customers.  Within each category is a list of customers, each with a total sale amount.  I'm wanting a report that shows the number of customers within each category that meet a certain threshold of sales.  A sample output would be as follows:

       

      RegionNumber of customers with at least $10,000 of sales
      East5
      West10
      North8
      South13

       

      I don't need to show the sales amount, just the count of those that meet the threshold within each category.