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

    Creating Years in Calculated Dimension

      Hi,

       

      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.

       

      Madhu