There is a requirement that we need to chart which does forecasting for next 3 years. The problem is the values displayed in a bar chart for this forecasting is calculated dynamically based on various inputs and the data field from when the forecasting has to start is a user input. Based on a date that the user inputs how do I generate next 3 years in calculated dimension.
I know how to extract year from the date but how do I get in the dimension the next 3 years.
Request you guys for help.
Thanks in advance.