0 Replies Latest reply: Nov 18, 2016 3:24 PM by chandu xyz RSS

    Need help for Caluculated Dimension

    chandu xyz

      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:

       

                   

      JanFebMarAprMayJunJulAugSepOctNovDec
      Utilization
      Plan count555555555555
      Forecast count566
      Actual count55
      Actual count- Plan count
      Forecast Vs Clar Ft011
      Forecast - Plan
      Clar Ft577777777777
      Plan Vs Clar Ft022222222222
      Actual Vs Clar Ft02

         

      Please find the attached Samples files