This content has been marked as final. Show 2 replies
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 Law||International Law Cases|
|Team Name||Win||Cases||% Won||Win||Cases||% Won|