Hi

I don't know what results you expected but the formula you wrote will divide all the Customer IDs in 4 equal groups by count (I.E. 25 % of the customer ID's in each group regardless of how much they spend. If you wanted them grouped by the SPEND range in your problem statement then the formula would look like

IF sum([spend])<10000 then '0-25'

Elseif sum([spend])<30000 then  '25-50'

elseif sum([spend])<75000 then '50-75-'

else '100' end

So - don't know if this helped but it all depends on your expectations

Jim

Good Morning

This was more difficult than it appeared - every time I tried using the table calculations for percentile it determined the groupings by record count and not total sales - I did not think it was suppose to work that way -

So I did it the by creating a series of formulas to do the calculation the way you would in excel

I used superstore data

1. determine the total sales >>{ Fixed (YEAR([Order Date])=2016):  SUM([Sales])}
   1. I hard coded in the year 2016 you could use a parameter
2. create a running total % of total sales >>RUNNING_SUM(sum([Sales])/sum([fixed sales]))
3. Break the running total into 4 parts >>if [Assign % by total sales] < .25 then '75-100%'

              Elseif [Assign % by total sales] < .5 then '50-75%'

              Elseif [Assign % by total sales]< .75 then '25-50%'

              else '0-25%' end

To get this to work the sales had to be sorted descending - not what I wanted but the only way I could get it to work

here is screen shot

Here is a portion of the attached excel I used to check the totals - note the sales $ are approx equal in each group

Let me know if this helped

Jim