9 Replies Latest reply: Feb 14, 2013 3:14 PM by Celambarasan Adhimulam RSS

    Expression to divide one column by the total of another

    Chad Gambone

      I have data formatted like the first 3 columns in a pivot table, and I want to create the fourth:

       

      YearValue1Value2Expression
      Other-15,0007.5%
      2011-50,00025.0%
      2012-40,00020.0%
      2013200,00030,00015.0%
      Total200,000135,00067.5%

       

      For example, the 7.5% is 15,000 (Other Years Value2) / 200,000 (Total Value1).

       

      How do I accomplish this?  Thanks.