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]
You can change the format of date values with the date() function: date([MyDate],'MM/DD/YYYY'). You can use the date() function in the script, but also in chart expressions and calculated dimensions. In most chart objects you can also change the number format of a expression column on the Numbers tab of the objects properties window.