Need to do a sumifs on <= date

I need to basically do a sumif on a value in column C and group by initiative and date (for any date <= current row date)

i've attached my workbook

Output

Optimization

Accepted answers

Hi @pateldev22, please give the attached approach a try on your larger dataset.

Hi @pateldev22, given what you are looking to compute, you can achieve your results in two ways:

1) Using the following logic within the multi-row formula tool

IF [Date]>=[Row-1:Date] 
	THEN [Undiscounted]+[Row-1:SUMIF_OUTPUT]
ELSE [Undiscounted]
ENDIF

2) Using Alteryx's native RunningTotal tool

I hope this helps.

Try this.

Please mark as solution + like, if it works for you.

The workflow is attached.

Cheers!

this does not work, sorry in my example i only had one unique date, but in my real data set i have multiple dates