Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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
What all dimensions do you have in this chart?
For the rows, the dimensions are:
And the column dimension is 'Attainment'
Thanks
Matt
Does have anyone have any nuggets of info they could offer?
Thanks
Matt
Can you share some sample table?
Try with
Count(Attainment) / count(total <[Report Cycle.autoCalendar.YearMonth]> Attainment)
Try:
Sum(Attainment) / Sum(Total Attainment)
it should work for you. Don't forget to format the number as %
Hi,
Unfortunately this doesn't work... The result is the same as in the example I showed.
Matt
Hi Carlos,
Unfortunately, this also doesn't work. I have the same result as above.
Matt
Yes, I'll remove names etc. from the data and upload it ASAP.
Thank you,
Matt