Last 3 months calculation

[Anonymous]

Hi All,

In the  below Qvw there is AMS (Average monthly Stock ) --

Distributor stock Value/ last 3 months of Indirect sales Value

Example : if we are in Jun-2015 the value should be 273,589/1,026422+468,380+503,819/3

the above condition is satisfied but when we are selecting Mar-2016 year and month filter ,

the APR-2015, MAY-2015 is not capturing last 3 months data  (it is calculating only previous month data)

can we do capture back end data in the table?

can any help on this??

Regards,

Devendar

[Anonymous]

yes, that last column backward stock coverage volume ,just look at the 2 charts, the value is not matching

the same expression applied in both charts but dimension is different

[Anonymous]

Any luck??