8 Replies Latest reply on Feb 21, 2012 12:05 PM by Sean Trout

    Finding count of customers with sales between "X" & "Y"

    Sean Trout

      I'd like to be able to take a dataset and find the number of customers with sales between a minimum and maximum level, over the course of multiple quarters.  I've been able to setup a filter to eliminate customers with sales that fall outside of my desired range.  But I can't seem to find a way to get an accurate count of the customers, as Tableau is counting each transaction for a customer, rather than each customer individually.  For example, if the customer place 3 orders in a given quarter, the count of customers for that customer is 3, rather than 1.  Any thoughts on how to correct this issue?