Need Help

anonymous008_G

Hi,

Can someone please guide me, how can we add one more record in the below table which would be sum of all FX Forward records just like expected output table.

Input table:- 

Sector	Long	Short	Gross	Net
FX FORWARD_DKK	1.85		1.85	-1.85
FX FORWARD_EUR	5.2		5.2	0.1
FX FORWARD_GBP	0.81		0.81	-0.81
FX FORWARD_NOK	1.68		1.68	1.68
FX FORWARD_PLN	0.92		0.92	0.92

Desired output:-

Sector	Long	Short	Gross	Net
Derivatives	10.46	0	10.46	0.04
FX FORWARD_DKK	1.85		1.85	-1.85
FX FORWARD_EUR	5.2		5.2	0.1
FX FORWARD_GBP	0.81		0.81	-0.81
FX FORWARD_NOK	1.68		1.68	1.68
FX FORWARD_PLN	0.92		0.92	0.92

davidskaife

Hi @anonymous008_G 

Here is a way of doing it using the Summarize tool and Union tool - i've created new columns where they might not exist after the Summarize Tool, sorted into the right order, and adjusting the output order from the Union after unioning on position

Note: you'd have to adjust the workflow if/when data appears in the Shorts column but this should give you enough to go on

Totals.yxmd