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