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
