Multi-Row Formula help needed

[ktberger_2020]

I'm having a hard time figuring out how to use the Multi-Row formula tool. 

In the table below, I'm trying to create columns that sum each PayType that happens between the Voided Payment PayTypes. I guess this would be grouped by SourceStore, Agree #, PayType of Voided Payment, and PayDate. Below is an example of the data and under that would be the desired output.

SourceStore	Agree #	PayDate	PayAmt	PayType
C0204	36945	1/15/2020 12:29	-11.5	Voided Payment
C0204	37295	2/29/2020 14:03	-150	Voided Payment
C0204	37295	3/20/2020 16:23	35	Extension
C0204	37295	3/27/2020 19:53	-152	Voided Payment
C0204	37390	3/7/2020 17:14	-51.3	Voided Payment
C0204	37390	4/14/2020 11:20	47	Extension
C0204	37390	4/15/2020 9:20	25	FreeTime
C0204	38519	3/13/2020 17:47	-64.82	Voided Payment
C0204	38519	7/2/2020 16:53	-64.94	Voided Payment
C0204	38519	1/28/2021 13:32	-129.88	Voided Payment
C0204	38519	2/20/2021 11:26	64.94	Extension

Desired Output:

SourceStore	Agree #	PayDate	PayAmt	PayType	ExtensionSum	FreeTime Sum
C0204	36945	1/15/2020 12:29	-11.5	Voided Payment	0	0
C0204	37295	2/29/2020 14:03	-150	Voided Payment	35	0
C0204	37295	3/27/2020 19:53	-152	Voided Payment	0	0
C0204	37390	3/7/2020 17:14	-51.3	Voided Payment	47	25
C0204	38519	3/13/2020 17:47	-64.82	Voided Payment	0	0
C0204	38519	7/2/2020 16:53	-64.94	Voided Payment	0	0
C0204	38519	1/28/2021 13:32	-129.88	Voided Payment	64.94	0

Any help is much appreciated because I can't wrap my head around how to do this. Thanks.

[SPetrie · Accepted solution]

See if this works for you.

I used the multi-row to associate the Non-Voided Payment item with the Voided Payment that came before it, used a crosstab to roll-up and sum the columns and then joined it back to the Voided Payment that it was associated with.

[ktberger_2020]

That is exactly what I needed. I think I got locked into thinking that I could get my final product through the multi-row tool and forgot that it could just be a step to getting the final product. This helped for my current issue and it helped my thought process in using this tool in the future. Thank you very much.