3 month moving average Market share

[leni_harishwara]

Hi All,

Can anyone help me in calculating Market share for 3 month moving average?

I am using a formula something like below,

RangeAvg(Above(sum(Value),0,3)/RangeAvg(Above(sum(Total Value),0,3)

Regards,

Leni Balakrishnan