5 Replies Latest reply on Jan 20, 2013 5:45 PM by Dimitri.B

    Dimension Value Lookup in Calculation

    Ron Pitts

      I'm wondering what options are available as regards to
      referencing other values for a calculated value.

       

        Basically a data source as follows:

       

      StateProductMonthValue
      ATotal4500
      AA4200
      AB4100
      BTotal4600

       

       

      I need to obtain a percentage against product A & B from the value contained in “Total” for the given State, e.g. lookup the “Total
      ” value when performing the calculation for the given state.