Logic Help

[abhaysingh]

Hey Guys,

I am attaching  one sample with the desired output ,

Need to compare the Record, Pls chk the sample file and desired output in it.

[tresesco]

PFA

Created a dummy expression and hide it.

Edit: Edited the date dimension.

[abhaysingh]

Hi Tressesco,

this is not the required output m luking ,

Pls find the new refined desired output sample app.

thanks for support

[tresesco]

Try the expression:

sum({<LinkDate+={'-'}>}Qty)

[abhaysingh]

Hi Tresesco,

i hope  i was not so clear with my last sample app,

the desired output attached here please have a look.

Thanks for your support and hope m clear

[tresesco]

Your data and explanation are not matching.

[abhaysingh]

bwart	key_bwart_xblnr	101_xblnr	101_Key	qty	xblnr
641	641|1001	101|1001		10	1001
641	641|1002	101|1002		20	1002
101	101|1005		101|1005	10	1005
101	101|1002		101|1002	20	1002
541	541|1003			30	1003
542	542|1004			40	1004
543	543|1005			50	1005

in the above data i 101_xblnr is not equal to 101_Key, than can i get the others.

i.e. value 101|1002 is not equal to 101|1001 than can i get 10 as output??