I have sales reps that have a series of metrics (calculated members) assigned to them. If their sales are over a certain amount I need to count them as one group, and if the sales are under that amount, I need to count them in a different group.

However, I then need to count the number of reps that fall within arbitrary ranges (buckets) also. I thought about the descritize method but I need to be able to tightly control the dollar ranges of the buckets.

Any help is appreciated.

**View Complete Post**

## How to filter customer count on the previous 3 months

Hi, I want to see the total number of new customers for the last 3 months and also the total the total number of existing customers.I have created a meaure called "Customer Count" which gives me the total number of customers. How will I use the date range in MDX to filter these?

I want to see this in MDX for a KPI. Can anyone help out?

Thanks

Sam