2 Replies Latest reply on Aug 17, 2017 3:48 PM by Shinichiro Murakami

    Column Grand Totals - Issues getting Grand Total or Avg of a Percentages

    Ce Lin

      I selected 'Show Column Grand Totals' on my data and am seeing the following. On the Grand Total line, the Win and Cases columns are summed up. However, I'm unable to get the % Won to show the summation or the average of the values. Can someone explain how summations down a column of percentages work and if there is a way to show the average percent won?

       

      If not directly on the same sheet, how would I go about creating a summary page with the sum of cases won, sum of cases overall by category, and the average win percentage?

       

       

      Corporate LawInternational Law Cases
      Team Name WinCases% Won WinCases% Won
      A8811,61055%641,6104%
      B6516639%01660%
      C05430%15440%
      D17223174%2823112%
      Grand Total1,1182,55044%932,5514%

       

      Thanks!