Fill up last value in pivot chart

[tombombadil]

Hi,

I hope someone has an idea, how to solve my problem.

I have a pivot chart, where I try to calculate an rolling average of the last 3 month - Row Test:

Sum(Aggr(Rangesum(Above(Sum(Repair_Cost_Total), 0, 3)), Monthyear))
+ Sum(Aggr(Rangesum(Above(sum( {<Warranty_Field=, Quality_Field=, Delete_Field=>} Return_Credit_Amount), 0, 3)), Monthyear))

This works fine!

Pivot

Now, I would like to continue the last entry of Test, for all upcoming months.
I want to fill in the 680.151,46 in all right fields, where it is 0,00 now.

Anyone has an idea, how I can do this?

Best regards
Tom

[Brett_Bleess]

Tom, quite a few historical posts on this topic, hopefully one of the following links will get you what you need...

https://community.qlik.com/t5/QlikView-App-Development/6-month-rolling-forecast/m-p/1273774#M400346

That is likely the most relevant one I think, if that does not work, feel free to search within the QlikView forum for the other posts related to 'forecasts' to see if any of those may help too.

Regards,
Brett