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).
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!