Hello Community, I've browsed through several threads related to replicating Excel's SUMIFS function in Alteryx, but haven't been able to find any solutions that seem to work for my use case. Essentially, I'm trying to calc year-to-date, quarter-to-date, month-to-date & week-to-date sales given a transaction date for each row (the period end date) and period beginning dates for year/quarter/month/week.
The attached file has the transaction date in column A, sales that need summed in column C, period beginning dates in columns H-K, and the summary calcs I need to produce in columns L-O (easy to do in Excel, but I can't quite seem to replicate in Alteryx).
I think the solution has something to do with utilization of filter/summarize/multi-row tools, but I'm struggling to find the right combo. Any help would be greatly appreciated!
