Combining/Summarizing Data

[Cspen]

I am looking to combine and add these two tables into one to show combined total of high, low, medium. Which tool would I need to use as the summarize tool is not combining them. Thanks in advance!

[binuacs]

@Cspen you need to calculate the combined sum before bringing it into the table tool, once you have the sum bring the data to table tool

[Cspen]

@binuacs  I have tried to sum the data before hand and it is not giving me the correct information I need. It is not adding things correctly 

[binuacs]

Union the input files based on position and calculate the sum sing summarize tool make sure group by Initial HRA field

[Cspen]

I have done this however the sum via the summarize tool is greyed out for me so I cannot calculate. I have already union the input files to the position they need to be 

[binuacs]

Check  your count field is numeric, if not change to numeric data type using a select tool and try again 

[Cspen]

Changing the numeric field allowed me to find the sum but then it changed the data so it does not show the sum of High, medium, low.. Just the overall  sum, I know this is an easy fix but I can not seem to figure it out. 

[nagakavyasri]

Count needs to be in numeric and HRA in string. In summarize tool, Group by HRA and Sum the count.

[binuacs · Accepted solution]

@Cspen Sample workflow attached