Hi
I facing an issue to create a calculated dimension, i need to show forecast-Plan and forecast- Actual value as separate dimension in the chart.
Forecast is nothing but 1+11 F,2+10 F ,3+09 values
Please find attached pic as reference.
Above is the object i have created along with this i need other dimension as:
Forecast-Plan & Forecast-Actuals
Forecast-Plan -40 for Jan month(Formula-(1+11 F - Plan i.e 10-50=-40)
-8 for Feb month(Formula-(2+10 F - Plan i.e 21-29=-8)
same way for remaining as well till December month
Here is sample file and qvw please find .