Add totals Query

henrygeorge

Hi,

How do we add totals from left and right when we have dynamic fields without using the Add Totals crew tools

Eg: the columns can change with every run to 4_5,5_6,etc the fields have to add up

This is my Workflow

Name	1_2	2_3
Hank	1	2
Jeff	3	4

My output should be -

Name	1_2	2_3	Total
Hank	1	2	3
Jeff	3	4	7
Total	4	6	10

JosephSerpis

Hi @henrygeorge I mocked up a workflow that produces the output you describe. The Crosstab tool has a Total Row and Total Column method of aggregation you can use you just need to scroll down to them in the configuration window of the crosstab tool. 

Total_19062020.yxmd