Hi Guys,
I am Having a scenario where i have data in following Format
Plant | Material | Status |
A | 111 | Moving |
B | 111 | Moving |
C | 111 | Moving |
D | 111 | Non Moving |
E | 111 | Slow Moving |
and Have to acheive below table in Front End.
Plant | Material | Status | Non Moving Status in other Plant | Non Moving Plant in other Plant | Slow Moving Status in other Plant | Slow Moving Plant in other Plant |
A | 111 | Moving | Non Moving | D | Slow Moving | E |
B | 111 | Moving | Non Moving | D | Slow Moving | E |
C | 111 | Moving | Non Moving | D | Slow Moving | E |
D | 111 | Non Moving | - | - | Slow Moving | E |
E | 111 | Slow Moving | Non Moving | D | - | - |
Thanks in Advance.