Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
mattcorke
Contributor II
Contributor II

Pivot table percentages from count of values

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

9 Replies
sunny_talwar

What all dimensions do you have in this chart?

mattcorke
Contributor II
Contributor II
Author

For the rows, the dimensions are:

  • Pupil assessment data.Subject
  • Report Cycle.autoCalendar.YearMonth

And the column dimension is 'Attainment'

Thanks

Matt

mattcorke
Contributor II
Contributor II
Author

Does have anyone have any nuggets of info they could offer?

Thanks

Matt

zebhashmi
Specialist
Specialist

Can you share some sample table?

stigchel
Partner - Master
Partner - Master

Try with

Count(Attainment) / count(total <[Report Cycle.autoCalendar.YearMonth]> Attainment)

clondono
Creator III
Creator III

Try:

Sum(Attainment) / Sum(Total Attainment)


it should work for you. Don't forget to format the number as %

mattcorke
Contributor II
Contributor II
Author

Hi,

Unfortunately this doesn't work... The result is the same as in the example I showed.

Matt

mattcorke
Contributor II
Contributor II
Author

Hi Carlos,

Unfortunately, this also doesn't work. I have the same result as above.

Matt

mattcorke
Contributor II
Contributor II
Author

Yes, I'll remove names etc. from the data and upload it ASAP.

Thank you,

Matt