Change the calculation to look similar to the following:
if sum([value])<=60 then 1
elseif sum([Value])>60 and sum([Value])<160 then 2
Then, you can add a window_sum to the calculation to find the total.
Hope this helps!
I put the code in calculation 1. Thank you!! I can see by the graph that it sorted the numbers correctly into 3 bins and graphed either a 1, 2, or 3. so then i should make a new calculation field to add those up?:
can I use grand totals instead to get the total points (sum of all the 1s 2s and 3s?)