Need help on Calculated dimensions

[#1]

Hi

I have two different files

1. Sample.xlsx

2.Clar FT.xlsx

There is no associate as of now in Data Model between this two files.Now i need to create a 1 object based on above two excel files.

There is Plan ,Actual, Forecast in Sample.xlsx which is input file  based on that i need to calculate values on monthly basis.

Plan Count-It is nothing but total count of values in Jan fields from Plan sheet(same way for other values also like Feb,Mar,Apr...etc).

Actual Count-It is nothing but total count of values in Jan fields from Actual sheet(same way for other values also like Feb,Mar,Apr...etc).

Forecast Count-It is nothing but total count of values in Jan fields from Forecast sheet(same way for other values also like Feb,Mar,Apr...etc).

Utilization -it is calculated based on Actuals n forecast(total actual/total forecast).

Clr FT: this values coming from 2nd Excel file(Clar FT).it is calculated based Amount and Amt/Ft(total Amount/Amt FT).

the above Fields are calculated Dimensions.Based on above calculations i need to show Actual count-Plan count and forecast count-Plan count

Finally as Below Object i required:Sample Output

                                       Jan  Feb  Mar  Apr  May  Jun   Jul   Aug  Sep  Oct  Nov  Dec

Utilization  

Plan count                          5     5      5     5     5       5       5      5       5     5     5      5

Forecast count                    5     6      6

Actual count                        5     5

Actual count- Plan count   

Forecast Vs Clar Ft               0    1     1

Forecast - Plan

Clar Ft                                5      7       7    7     7      7       7     7       7      7     7     7

Plan Vs Clar Ft                   0       2       2    2    2      2       2     2        2     2     2      2

Actual Vs Clar Ft                 0      2

Please find the attached Samples files