Difference for multiple unstructured line items

[Rafiuddin_333]

Hello everyone,

I am a newbie exploring Alteryx and I have encountered a problem for which I need your help in solving. 

Particulars	Cost (x)	Products	Cost (Y)	Variance (X)-(Y)
Item 1	2000	A	100	1500
		B	200
		C	100
		D	100
Item 2	500	E	150	250
		F	100
Item 3	100	G	50	50

From the above table, for Item 1 which is linked to 4 products I need variance of Item 1 and sum of its products related to it I.e sum of A+B+C+D So 2000-(100+200+100+100)=1500.

Likewise for Item 2 its 2 products E & F so 500-sum(150+100)=250

With the above example is it possible i can get variance column in Alteryx that shows me the combined products with variance?? 

Thank you very much for your help!

Regards,
Radic

[griffinwelsh]

See the attached solution

[flying008]

Hi, @Rafiuddin_333 

FYI.