5 Replies Latest reply on Oct 7, 2016 1:35 AM by Mahfooj Khan

    Calculate percentage  for each quarter

    Dale Forman

      Hi All

       

      I have data each quarter like below. Four column for each quarter.  I would to calculate percentage value for each quarter.

       

      Something like this  # Sales Q1 / ( Sales Q1 + Sales Q2 + Sales Q3 + Sales Q4)

       

      Can anyone help me for this ?

      Thanks

      Dale

        

      StateSales Q1Sales Q2Sales Q3Sales Q4
      Alabama207361192175
      Arizona391402140290
      California105236278466
      Delaware209308218319
      Florida362401433202
      Illinois393213163399