3 Replies Latest reply: May 31, 2011 3:41 AM by Vesa Sääski RSS

    How can I use calculated dimension in difference calculation

    Vesa Sääski

      Hello,

      I am having problems with calculated dimension.

       

      I would like to calculate variance for different data versions as shown in really simple example below...

      Dimension is Version and Expression definitions are in below.

      So, how should I calculate the variance for Versions?

       

      Expressions       ActualBudgetVariance
      =sum({$<Version = {'Actual','Budget'}>}Sales)Sales50045050
      =sum({$<Version = {'Actual','Budget'}>}Costs)Costs35833028
      =((column(1)-Column(2))/Column(1)Margin%28%27%2%

       

      Data model is like below:

      FieldData
      Version(Actual, Budget...)
      Sales

      (values)

      Costs(values)