Could you attach a sample dataset?
Thank you for the sample. Have you tried a conditional statement that looks at the volume and groups the value based on a specific threshold? The important thing here is to order the classes from the highest to the lowest buckets.
In the example above I've used a table calculation to compute the median value, so if the data is updated you will always obtain the most current median.
Let me know if this helps.
I don't want to compare the volume with the median. I'm trying to do something like an ABC analysis, so I need group with the 70%,70-90%, 90-100% of the buyers group by amount of volume.
If I have 10 clients, I need 7 of then with the lowest volume and 1 with the highest volume.
customer volume ABC
client 1 0.1 C
client 2 0.1 C
client 3 0.3 C
client 4 0.4 C
client 5 0.6 C
client 6 0.6 C
client 7 0.6 C
client 8 0.8 B
client 9 0.8 B
client 10 1 A
Have you already tried the following adapted formula?
If SUM([Volume])<0.7 then 'C'
ELSEIF SUM([Volume])>=0.7 AND SUM([Volume])<0.9 then 'B'