4 Replies Latest reply on Mar 18, 2016 1:31 PM by pooja.gandhi

    Divide values of a measure based on their dimension criteria

    brenda.kimiywi

      Hi All,

       

      I am trying to divide the 'Per Member' value below of the test groups by the control i.e In Feb, I need to divide 0.0996/0.0816 for test1 etc. Desired outcome is the 'Lift' column. Is there a way to achieve this in Tableau?

       

      Thanks

       

          

      MonthCell CodePer MemberLift
      Feb-16Control0.0816
      Test10.09961.2207
      Test20.10471.2836
      Test30.09841.2069
      Mar-16Control0.2058
      Test10.12870.6254
      Test20.14900.7239
      Test31.48577.2194
      Test41.46657.1259