Multi row conditional running average

BosKev

Hi,

I'm looking for a setup with the multi row tool that will be able to calculate the average based on Year/Month or more criteria.

Below sample I would like the multi row tool to calculate for "RunningAverage"

Thanks.

YEAR	MONTH	LINE_OF_BUSINESS_NAME	Job Type	Sum_Count	RunningAverage
2020	2020 / 01	GW	ABC	10656	10656
2020	2020 / 02	GW	ABC	10621	10639
2020	2020 / 03	GW	ABC	10555	10611
2020	2020 / 04	GW	ABC	10513	10586
2020	2020 / 05	GW	ABC	10437	10556
2020	2020 / 06	GW	ABC	10409	10532
2021	2021 / 01	GW	ABC	10636	10636
2021	2021 / 02	GW	ABC	10601	10619
2021	2021 / 03	GW	ABC	10535	10591
2021	2021 / 04	GW	ABC	10493	10566
2021	2021 / 05	GW	ABC	10417	10536
2021	2021 / 06	GW	ABC	10389	10512

atcodedog05

Hi @BosKev 

Here is how you can do it.

Workflow:

Hope this helps : )

Running Avg.yxmd