9 Replies Latest reply: Feb 22, 2018 12:06 AM by Matt Corke RSS

    Pivot table percentages from count of values

    Matt Corke

      Hi there,

       

      I'm trying to create a pivot table that shows the percentage of a count of values. The rows should equal 100% (for each date).

       

      pivot table percentages.jpg

       

      At the moment I've used this:

      Count(Attainment) / count(total <[Pupil report data.Subject]> Attainment)

       

      This isn't working as it is returning a total of 100% for every value in the pivot table, not by row or subject.

       

      Any ideas would be much appreciated!

       

      Many thanks

      Matt