Straight table Comparison with alternate State

[g_santhosh86]

Hi,

Table with data in below format 

Yr	Base 5	Part	Plt	Cost
2020	12345	12345AA	P1	100
2020	56789	56789AA	P1	50
2021	12345	12345AA	P1	110
2021	12345	12345AB	P1	110
2021	56789	56789AB	P1	55

Created Filter 1 with Alt_State1 for Yr 2020 Selection(Prev Yr) and Filter with Alt_State2 for Yr 2021 Selection(Curr Yr) and I am looking for the result in straight table as below

Base 5	Plt	Prev Yr Part	Curr Yr Part	Prev Yr Cost	Curr Yr Cost	Diff
12345	P1	12345AA	12345AA	100	110	10
12345	P1	12345AA	12345AB	100	110	10
56789	P1	56789AA	56789AB	50	55	5

The part 12345AA is once in Yr 2020, but the Base 5 for both yr are same, I need to repeat twice to match to both the parts 12345AA and 12345AB from Curr Yr.