I have identified a flag to determine whether a sale occurred on my database. however sometimes the same customer can have a sale on the same day or with in a 30 day period etc. I want to flag it as a sale because I want to add up my sales volume total but I also need to count the number of unique customers that has a sale during that period.
right now ... I have a summary field that sums the told number of sales for a specified period. but what I really want is the number of distinct customers that had a sale for a specified period ... say the last 30 days.
Can you point me in the proper directions... thanks,