Scenario

[bohravanraj]

Hi Guys,

I have a Scenario in below Format :

Plant	Material	Status
A	111	Moving
B	111	Moving
C	111	Moving
D	111	Non Moving
E	111	Slow Moving

and I Have to achieve below Table in Front End

Plant	Material	Status	Non Moving Status of other Plant	Non Moving Plant of Other Plant	Slow Moving Status  of Other Plant	Slow Moving Plant  of 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

[swuehl]

Maybe like attached, using a chart with dimensions Plant, Material, Status and expressions like

=If(Status <> 'Non Moving', 'Non Moving','-')

=If(Status <> 'Non Moving', CONCAT(TOTAL {<Status = {'Non Moving'}>} Plant, ', '))

Probably not exactely what you want, but the best I get with the information provided.