How to sum values base on date using multi-row formula

[Chalsea]

Hi there,

I would like to get some help on how to sum values base on date using multi-row formula.

In the attached file, I would like to dynamically create a new column call daily sum base on the individual date. For example, aggregating all 5/2 impression data into one. Can you please help?

Thanks so much in advance!

Chalsea

[grossal · Accepted solution]

Hi @Chalsea,

it sounds that you are looking for a Summarize Tool in combination with the Join:

Result:

Sample Workflow attached. Let me know what you think.

Best

Alex

[Chalsea]

Thanks so much! That works!