Hi, I have assigned 100 accounts to my agent in beginning of the month.
He worked upon 10 accounts on day 1, 2 accounts in day 2, 5 accounts in day 3 and the total accounts worked by him were 72 in the month.
I want to make a pivot table that shows his daily performance.
i.e. on day one his work percentage was 10% (10/100), on day 2 his work percentage was 12% (10+2)/100 and so on.
attached is the raw sheet that I am using to make pivot table.Sample-data.xlsx