Forum Discussion
YoY comparison
I have the data in a table format on the left, I would like to generate a YoY table on the right
| Date | Value | 2021 | 2022 | ||
| 2020/01 | 25 | Jul 2020- Mar 2021 | Jul 2021 - Mar 2022 | ||
| 2020/02 | 45 | Value | 2025 | 4185 | |
| 2020/03 | 65 | ||||
| 2020/04 | 85 | ||||
| 2020/05 | 105 | ||||
| 2020/06 | 125 | ||||
| 2020/07 | 145 | ||||
| 2020/08 | 165 | ||||
| 2020/09 | 185 | ||||
| 2020/10 | 205 | ||||
| 2020/11 | 225 | ||||
| 2020/12 | 245 | ||||
| 2021/01 | 265 | ||||
| 2021/02 | 285 | ||||
| 2021/03 | 305 | ||||
| 2021/04 | 325 | ||||
| 2021/05 | 345 | ||||
| 2021/06 | 365 | ||||
| 2021/07 | 385 | ||||
| 2021/08 | 405 | ||||
| 2021/09 | 425 | ||||
| 2021/10 | 445 | ||||
| 2021/11 | 465 | ||||
| 2021/12 | 485 | ||||
| 2022/01 | 505 | ||||
| 2022/02 | 525 | ||||
| 2022/03 | 545 |
Anonymous
you can use filter
pls see the attachment below
