Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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