All templates
Analysis
Year-on-Year Comparison
Compare this year against last year, month by month.
Comparison3 rows
| # | AMonth | BThis year | CLast year | DChange | E% change | FCumulative |
|---|---|---|---|---|---|---|
| 1 | Jan | 7,980 | 6,900 | 1,080 | 15.7% | 1,080 |
| 2 | Feb | 8,815 | 8,100 | 715 | 8.8% | 1,795 |
| 3 | Mar | 9,810 | 9,950 | -140 | -1.4% | 1,655 |
What it tracks
- This year vs last year
- Percentage change
- Running totals
Included sheets
ComparisonData
Key calculations
- Change
- =ThisYear-LastYear
- % change
- =IFERROR(ThisYear/LastYear-1,0)