Scenario

bohravanraj — Mon, 29 Feb 2016 08:28:54 GMT

Hi Guys,

I have a Scenario in below Format :

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

Re: Scenario

swuehl — Mon, 29 Feb 2016 20:56:29 GMT

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.