Skip to Content
0
Former Member
Jan 17, 2006 at 10:12 AM

How to make a Moving total in Query Designer

74 Views

Hi,

I make trend analysis over sales.

Besides the actual sales figures, I would like to show a Moving Annual Total (MAT).

I can make this based on a specific period (using an offset of 0 to -11, and so on), but now I want to see the trend over an interval (for instance 12 month).

I am not able to incorporate the interval values into the period variable.

Can anybody help me with this?

Regards,

Erik Henning