Multi-Field Sum

[cpetten1]

Hello,

I'm currently working on a workflow where i need to sum a column based off an ID. I know that i can use the summarize tool to accomplish this, however, i have nearly 300 columns in the data set that i need to do this too and i don't want to create 300 summarize tools in my workflow to accomplish this. Does anyone know how to perform a multi-field summary? I've use the Multi-Field tool before, but i don't see a calculation option for sum. 

[binuacs · Accepted solution]

@cpetten1 Transpose your columns and take the sum using summaries tool. In summarise tool group by ID, Name , Sum Value, then cross tab the result

[SPetrie]

My first though would be a transpose and cross-tab with a sum option.

Can you share some example data and how its setup? It will be easier to assist if we can see how it looks going in and an example of what you want the output to be.

[cpetten1]

Thanks everyone. very simple solution, just didnt think about cross tabbing the results back to the original format. Works perfectly!