Hi
I have monthly data by segment by product family. - Refer to document attached
I would like to build dashboard to display last year, current year and variance column.

Therefore, i build 1 module, source, last year, current year and variance line item

Question:-
How to input formula to grab data for FY20?
How to input formula to grab data for FY21?
Beside year, i also need half year data
| | FY21 | FY20 | Variance |
| | 1H | 2H | | |
| | AUDm | AUDm | AUDm | % |
A | PA | | | | |
| PB | | | | |
| PC | | | | |
B | PA | | | | |
| PB | | | | |
| PC | | | | |
C | PA | | | | |
| PB | | | | |
| PC | | | | |