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.