2 Replies Latest reply on Sep 18, 2017 12:23 PM by Gina Battinich

    Use of Grand Totals for a Percentage Column

    Gina Battinich

      I'm on version 10.0.5.

       

      I have a worksheet where I've got 2 columns of data (actual and goal) and a 3rd column that computes the percentage for each row.

       

      I'm using the Grand Totals function as my last row in the worksheet.  It is correctly totaling my actual column and my goal column, however; it is also totally the percentage column.  I want this displayed as a percentage of the 2 total columns...so in the example below, I would expect the result in the grand total column for % of Goal to be 93.70%.

       

      Can anyone tell me how to do that?

       

      Thanks in advance,
      Gina