Daily file to monthly average file

[Saga]

I receive this format file every working day. It has multiple rows and columns. I want to calculate monthly average of num created, num actioned, percentage completed, overdue < 5 days, => 5 days, of each of the sub component loans, deposits, auth overdrafts, unauth overdrafts, cash etc. for each market and platform. I want the average every month. Struggling with 30 sheets now.

[clmc9601]

Hi @Saga,

Is this what you're trying to get?

 

I hope it helps!