Help With Ranking Using Multi-Row Formula Tool

[benmillea]

I want to add a new "Ranking" field to my data based on position. The data is sorted on the "%RR Wgt" column and then by week number. 

So machineId 116 will get 1 point, 118 will get 2 points and so on. The bit that I need help on is when I get down to week 2, I want to start this ranking process again

So machineId 116 again gets 1 points, 45 gets 2 points and so on until we get to week 3 and then start again

I think I need the multi-row formula tool but I don't know what the formula is!

Many thanks

[Qiu · Accepted solution]

@benmillea 
An important one is we need to check the group feature.

[benmillea]

Perfect! Thank you