It is Tricky, but done
So Please Have a look at Steps.
Did Rank Unique and Edited The Calc as per following
and Edited the Calculation as per:
Please note the yellow marking, I moved the Person as First Item To have Restarting Every Person.
So Once that was done, Created another Calc, Which is your Aggregated Rank
and Edited the Calculation it as per Following:
and it returns. Please See attached.
if it Helps, Please mark it Helpful and CORRECT to Close Thread.
questionWorkbook (1).twbx 12.0 KB
Deepak, apparently my similar application was a bit more complex than what I just had here, but your response was perfect for the example and also very helpful in helping me to further think through the final application for my other purpose. Thank you very much!