Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having a problem with creating a forecast line chart for the next 5 years based on last year sales.
eg: Last year sales is 100 Mn and each year it should be increased by 1.5 (forecast 1st year 100* 1.5, forecast 2nd year 150*1.5).
the chart should be as below
Thanks
Amila
Hi,
May be try to use the expression like
Above(sum(sales)*1.5)
Hi Settu,
Thanks for your reply, I have tried this and only one year is showing. I need to show for next 5 years.
Thanks
Amila
Do you have 5 years in your dimension or calendar table?
Hi Settu,
I am having the last 2 years' data and no calendar data or dimensions for the future. I don't want to show the calendar year for the next 5 years and it is enough to show 1-5 in dimension (refer the image I shared).
Thanks
Amila