Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a chart that shows projected sales per year. the end user want to make it automated by adding pct to year over year..
the chart has
Year Projected Sales
2011` 1000
2012 1000
2013 1200
2014 1300
2015 1400
The end users wants to the chart to show future projected sales by using a variable and apply it to the current year so if the variable is 10% then the table will look like
2016 (1400 * 10%)+1400
2017 (2016 value *10%)+2016 value
and so one..
any ideas?
Best,
Alec
see this post, ...
Hi,
Try like this
Data:
LOAD
*
INLINE [
Year, ProjectedSales
2011,` 1000
2012, 1000
2013, 1200
2014, 1300
2015, 1400];
Concatenate(Data)
LOAD
Peek(Year) + 1 AS Year,
Round(Peek(ProjectedSales) * 0.1) + Peek(ProjectedSales) AS ProjectedSales
AUTOGENERATE 10; // I have given 10 for next 10 years, based on your requirement change this number.
Hope this helps you.
Regards,
Jagan.
Thank you both but both solution dont work for me.. the variable is set by the user on the front end using a slider so the forecasting needs to be within the chart....
Hi Alec,
Please find attached file for solution.
Regards,
Jagan.
thank you for your help!