Please find my solution attached as well as below screenshot for your reference.
1st, pivot your data as shown below
2nd, create calculation fields as below
Hope this helps
Book7_v10.2.twbx 40.4 KB
Perfect! This was part of a larger project and I believe I posted this question slightly out of context but your answer got me back on the right track.
I'll have to brush up on my LoD expressions.