Compare one row to all other rows

[minty]

Hi All, 

I have a set of data that has multiple rows with the same date. Is there a tool that could compare one row to every single row in the data set? Ideally, I would add the data associated with that date and create a new 'totals' column. I have attached a picture of what the data looks like right now below and would love to be able to add all 2020-07-18 data points together for example. 

Thank you! 

[DavidP]

I would play around with the summarize tool - group by date and look at the other options available. Add any other columns you need, then join back to the original date set.

[seven · Accepted solution]

Hi@minty 

the Summarize tool will give you the totals per date. You can then join those totals to the original data and have a totals column if that's what you want to do.

If this works for you, please mark it as a solution. If not, please explain how it faltered and also provide data in a file not a photo.

[minty]

Thank you so much for your help! That worked perfectly.