Hi all,
I have found a template that seems to do a sales report per customer per year however I am needing help with adding previous years columns. I have included a mini sheet.
I need to have on the one table 19/20 comparison to 21/22, 20/21 as % - to 19/20, also 21/22 comparison %+- to 20/21. I then will have two group of customers split into say regional and metro, they will need to be totaled per group and then a grand total for both groups.
The formula for I7 is: =SUM(OFFSET($C$6,ROWS($B$7:B7),0,,MONTH($C$4)))
I have found a template that seems to do a sales report per customer per year however I am needing help with adding previous years columns. I have included a mini sheet.
I need to have on the one table 19/20 comparison to 21/22, 20/21 as % - to 19/20, also 21/22 comparison %+- to 20/21. I then will have two group of customers split into say regional and metro, they will need to be totaled per group and then a grand total for both groups.
The formula for I7 is: =SUM(OFFSET($C$6,ROWS($B$7:B7),0,,MONTH($C$4)))