I have 12 periods of data, each batch's error took pervious period's error into consideration. I find it very difficult to do this operation is qlikview given the sheer size of the data and complexity of calculations. do you have any recommendation in terms of which program is good for this purpose, so I can use it in conjunction with qlikview, precal the values and have qlikview pull in the finished value for further graphical analysis.
table:
product market period target qty actual qty
A xx 1 34 21
A xx 2 22 42
B yy 1 2 9
A ff 1 4 0
error term for prod A and market xx in period 2 is E2=e2+correlation*E1
