Please find attached the packaged workbook. I used the sample superstore data to solve the problem. Do let me know if it works.
I have used quick table calculation to find the running total of sales.
Can you explain the profit margin calculation issue or attach a workbook?
Hope this helps.
Solution.twbx 2.4 MB