1 Reply Latest reply: Jun 14, 2015 11:47 PM by Madhu B RSS

    Creating Years in Calculated Dimension



      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.