Stuck with a Sumif Across 2 datasets

[neiledwa]

So I have a set of data that summarises by Period (P1,P2,P3,P4,P5 and P6) that have unique periods I need to sum spend for. The spend data by day is on a separate data set and I cant get my head around how to do it. In excel, its dead easy! But sadly I am new to Alteryx and my brain is still in Excel mode!

[PhilipMannering · Accepted solution]

Hi @neiledwa 

The trick here is to generate all the dates and do a join. See attached,

[messi007]

@neiledwa,

I have done this using a Macro batch :

1- Filter for each periode and calculate the sum

Run the batch for all periods:

Attached the workflow,

Regards,