Table calculation returns something result value WITHIN the window.
So if you want get the moving average based on the previous 12 weeks,
the window must contain the data of the previous 12 weeks.
And if you don't want to see the previous data, you have to filter those data,
The calculated field used in filter also must be table calulation,
so I use the function LAST() to search the latest week to show.
And uncheck 'Show Header' of the working field.
20160317_MovingAvg.twbx 1.1 MB