I have a table where there can be multiple rows for each week. That is because a field I am calling on 'Total tutors in block' can be 1,2,3,4,5... - I then have a field that tells me how many 'Tutoring Blocks' happen, associated to the number from 'Total tutors in block'.

I need a calculated field (or something similar) to get one row per week looking at 'Tutoring Blocks' / total 'Tutoring Blocks' for each of the 'Total tutors in block' records.

In SQL it looks like this
, sum(case when total_tutors_in_block = 1 then 1 else 0 end) as count_1_tutors
where we group by
Last lesson date week

Any help appreciated!