get Year over Year difference

[Ultralightbeam]

Hello guys I have a table below which is has the following

Year	Region	Line	Office	Count
2021	ASEAN	C	Indo	1
2019	ASEAN	C	MY	8
2020	ASEAN	C	MY	46
2021	ASEAN	C	MY	58
2020	ASEAN	C	PH	2
2021	ASEAN	C	PH	74
2019	ASEAN	F	MY	1

I want to get the Year over year difference if the row has 2019,2020 and 2021, Same Region, Line and office

Note that I have one country which has one year

Desired Output

Year	Region	Line	Office	Count	Output Percentage
2021	ASEAN	C	Indo	1	-
2019	ASEAN	C	MY	8	38
2020	ASEAN	C	MY	46	12
2021	ASEAN	C	MY	58	-
2020	ASEAN	C	PH	2	72
2021	ASEAN	C	PH	74	-
2019	ASEAN	F	MY	1	-

Thanks!

[phottovy]

HI @Ultralightbeam ,

I believe you should be able to accomplish this using the multi-row tool. See the attached workflow and make sure you use the group by option in the tool.