I think you need use window function and table calculation.
Can you provide a sample workbook with what you have done so far?
Thank you for your response. I actually don't have access to dummy data for this as I'm on the road currently. Would you have any suggestions based on what you see in the screenshot?
I think you may try window_sum() and set the table calculation as mentioned and drag the window calculation to detail.