8 Replies Latest reply on Jun 3, 2012 3:08 AM by Jonathan Drummey

    How to count customers with revenues > 10k per year?

    Mark Rees

      How do I count the number of distinct customers by customer segment where their total 2011 sales are at least 10000?  (and be left with only 4 rows, 1 per customer segment, with the total count of customers who have 2011 sales > 10000).

      sales.png

       

      In the example above, I created a calculated field that simply does:

      sum([Sales])>=10000

       

      I want to remove the customer from the row and have the count be correct. (the customers who are true).  How do I accomplish this?