5 Replies Latest reply: May 4, 2012 1:51 PM by Jeremy Boyer RSS

    summing across mulitple variables

    Jeremy Boyer

      I have a table that has the following columns:

       

      DateIDCount%
      5/3315x
      5/33210y
      5/43110z
      5/43215u

       

      I would like to sum the Count column for each combination of Date and ID so I can see the % of that day and ID that set makes up.

      I want:

      x = 5 / (5 + 10) = 33.33%

      y = 10 / (5 + 10) = 66.66%

      z = 10 / (10 + 15) = 40%

      u = 15 / (10 + 15) = 60%

       

      How do I set up the % column to do this?