Need help with complex ranking/cumulative scenario

Likely going to need to see a demo model to assist here.

Have you check out this tutorial here. It runs through a somewhat similar example I believe

Here is the actually forum post it was derived from

Thanks
Sam