SumIf Dates

[rwinner]

Hello - I am new to Alteryx and I am trying to find the best way to create a solution to this issue. For each row, I would like to have a new column that subtotals the amount listed and the prior two months of data for the state identified. As an example: If the state was PA, on the May 2022 line, I would like it to subtotal March 2022 through May 2022. 

Any help would be greatly appreciated!

[geraldo]

@rwinner 

to make it easier, you better put the rule for a period of one year

[acarter881 · Accepted solution]

Hello, @rwinner.

Please see the attached. The key is to group by state and use the Multi-Row Formula tool.

[rwinner]

Perfect thank you!