Could you clarify the table setup by providing a simple sample app?
It would be good to understand which columns are dimensions and measures in this example. Please also confirm what results you expect in the table when the measure is aggregated according to your expectations.
I have uploaded a Sample.qvf file and shared it with you.
In the above example there is only one measure in the table i.e value.
The new colomn (Rolling FC Value) is a new measure that 'i've created in my Master Items. The results should be the either the forecast value or the actual value from the value column - based on the currentWeekno variable that I've created.