2 Replies Latest reply: Mar 13, 2015 10:05 AM by Shiva Reddy RSS

    Forecast Dates Vs Actual Dates

    Ridhaa Hendricks

      Hi There

       

      I have an issue in my data.

      My actual Data is coming from the Db and my forecast Data is coming from excel spreadsheets

       

      The problem I am having is that the date that I am using to view the forecasts is limited to the date of the actuals.

      I need to see future dates for the forecasts.

       

      I have concatenated my forecast table into my actual table but I have had to remap the dates to create fiscal months

       

      all this is making the structure quite messy, is there a way I can tell the chart for the forecasts to look at the dates of the forecast field-[Fiscal YM] but Display it in a format of another field [Calendar Fiscal YM]

       

      I hope this makes sense...

       

      Thanks