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 · Accepted solution]

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. 

[grazitti_sapna]

Hi @henrygeorge , alternate solution to your problem.