Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community!
Consider the attached file.
I want to present an accumulated graph which plots the accumulated balance for the periods less than the selected month pluss the prognosis for the rest of the periods. All in one line, a dotted prognosis line would be nice.
Pls advice!
Best regards
Trond Erik
Like this?
See attached qvw.
Thx guys!
Gysbert, you are almost right. But you are only aggregating the Balance. The plot is flat the last few periods.
Also: How can I do this without using the accumulate function on the graph properties?
Best regards
Trond E
See this document: Calculating rolling n-period totals, averages or other aggregations