14 Replies Latest reply on May 30, 2017 3:12 PM by vita nesvetailov

    Difference between two columns

    Chris Smith

      I'm looking to calculate the difference between two columns in my data. In the attached sheet, I am trying to subtract column E and column C.

       

      Search term is a dimension

      Visits is a measure

      % of total is a calculated field - the formula for this is:  SUM([Sessions]) / TOTAL(SUM([Sessions]))

       

      Let me know if you need any additional information.