Hello Experts, I have a data set for the entire year 2018 and from that data set I would like to calculate the weighted average for last three months dynamically at a 'customer code' and 'material code' level. It is just one output that needs to be calculated at 'customer code' and 'material code' level from the data set. See below an example: How can I achieve in my alteryx workflow ? Two outputs from the below data set * Weighted Average for 'AA + CC' = 33.33 = ( (40*30 + 20*10 + 30*20) / (30 +10 +20)) * Weighted Average for 'AA & BB' = 300 = ((200*100 + 100*50 +400*200)/ (100 +50+200)) MonthCustomer codeMat CodeVolValue 201801AACC200809.82 201802AACC100404.94 201803AACC13,62044,793.65 201804AACC24,00088,099.69 201805AACC2,1007,743.08 201806AACC17,35763,634.82 201807AACC3040.00 201808AACC1020.00 201809AABB100200 201810AACC2030.0033.33201811AABB50100.00 201812AABB200400300

How to calculate dynamic weighted average from the data set

Hello Experts,

I have a data set for the entire year 2018 and from that data set I would like to calculate the weighted average for last three months dynamically at a 'customer code' and 'material code' level.

It is just one output that needs to be calculated at 'customer code' and 'material code' level from the data set.

See below an example: How can I achieve in my alteryx workflow ?

Two outputs from the below data set

Weighted Average for 'AA + CC' = 33.33 = ( (40*30 + 20*10 + 30*20) / (30 +10 +20))
Weighted Average for 'AA & BB' = 300 = ((200*100 + 100*50 +400*200)/ (100 +50+200))

Month	Customer code	Mat Code	Vol	Value
201801	AA	CC	200	809.82
201802	AA	CC	100	404.94
201803	AA	CC	13,620	44,793.65
201804	AA	CC	24,000	88,099.69
201805	AA	CC	2,100	7,743.08
201806	AA	CC	17,357	63,634.82
201807	AA	CC	30	40.00
201808	AA	CC	10	20.00
201809	AA	BB	100	200
201810	AA	CC	20	30.00	33.33
201811	AA	BB	50	100.00
201812	AA	BB	200	400	300