Hi everyone,
I hope you are keeping safe.
I am trying to calculate the revenue generated for a specific week based on monthly revenues. Is there a formula I can apply to do this? (i.e. I am trying to calculate the weekly revenue generated)
Input Table is set up like this:
Output table:
I hope you are keeping safe.
I am trying to calculate the revenue generated for a specific week based on monthly revenues. Is there a formula I can apply to do this? (i.e. I am trying to calculate the weekly revenue generated)
Input Table is set up like this:
Monthly revenue | ||
Jan-21 | Feb-21 | |
Joe | 1,000 | 0.00 |
Ben | 400 | 0.00 |
Kate | 200 | 600 |
Sam | 700 | 1,500 |
Output table:
Weeks | 1 | 2 | 3 | 4 | 5 |
Monthly revenue |