Dimension Issues

[#1]

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 .     

sample.qvw