I have a field that looks up the values of students marks using the Case function which returns a value, A, B, C, or F. The field is called 'Total Grade Sem1 Lookup'.
What I want to do is create a pie chart with the the labels of A, B, C, or F with the pie chart indicating those students that have an A, B etc. as a percentage. Unfortunately, when I create the chart, it shows all the students individually, e.g. if there are 25 students, it indicates 25 equal slices and the label repeats the grades of As, Bs etc. to the total number of students.
I have tried the tick box in Data Source, 'summarized groups of records' and 'individual record groups', but this does not alter the pie chart.
I am using FileMaker Pro Advanced, versions 12, 14 & 15.
Can anyone assist?