Sum up from different workflow and outputs

Question

Hi, need some help here as pretty new to alteryx.  i have created 3 outputs since they are from different data sources and it shows in Alteryx as exactly like these now. I need to group them get the variance for  Gross comm vs ledger and Stamp duty vs ledger for both products combined .  Variance  = A + B + Ledger

It can appear in 2 separate Lines as per below. I tried using join/union but doesnt seem to work, thanks

Output 1

NameValueGross Comm (A)20Stamp Duty (A)50

Output 2

NameValueGross Comm (B)80Stamp Duty (B)50

Output 3

AccountAmountGross Comm Ledger (A and B)-100Stamp Duty Ledger (A and B)-110

FINAL OUTPUT

Gross Comm (A)Gross Comm (B)Gross Comm Ledger (A and B)Variance2080-1000

Stamp Duty (A)Stamp Duty (B)Stamp Duty Ledger (A and B)Variance5060-1100

Felipe_Ribeir0 · Accepted Answer

Hi @clara777 ,

Here is a way to build the 2 outputs:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

Emmanuel_G · Accepted Answer

Hi @clara777 ,

Find attached the way of doing this simply.

Mark as solution if it helped please.