5 Replies Latest reply on Apr 15, 2019 1:51 PM by pratik.chaudhary

    Percentages in grand total row not adding to 100%

    Sean Morris

      Hi all. Below is a screenshot and attachment of a workbook where you'll see that, for each row, I am counting students and next to each count including the percentage of row total for each grade group. Everything works great, but a colleague pointed out that when filtering to certain Subject Codes (in this case 'BHHS'), the percentages in the grand total row add up much more than 100% (although the total in the right hand column does say 100%).

       

      Any insight as to what might be happening here? Thanks in advance!

       

      Sean