Compare one row to all other rows

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!

Screenshot1.png

Help

Accepted answers

seven

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.

total_amounts.yxmd

All comments

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

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.

total_amounts.yxmd

minty

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703