How to count (and get %) of students who met 70% of their tests?

[afaherty]

Hello,

I have been struggling with this for days and decided to reach out for help.

I need to get both the total and the percentage of students who met 70% of their math subtests (there are other school subjects in this data set but just trying to keep it simple for the example. I need to see it by "Test" not subtest). Thank you to anyone who may be able to help.

Here is dummy data:

User ID	Result	Test	Subtest
1	Met	Math	Fractions
1	Met	Math	Decimals
1	Met	Math	Equations
1	Not Met	Math	Word Problems
1	Not Met	Math	Statistics
2	Met	Math	Fractions
2	Met	Math	Decimals
3	Met	Math	Fractions
3	Met	Math	Decimals
4	Met	Math	Fractions
4	Met	Math	Decimals
5	Met	Math	Fractions
5	Not Met	Math	Decimals
6	Met	Math	Fractions
6	Not Met	Math	Decimals
7	Met	Math	Fractions
7	Met	Math	Decimals
7	Met	Math	Equations
7	Met	Math	Word Problems
7	Met	Math	Statistics
8	Met	Math	Fractions
8	Met	Math	Decimals
9	Met	Math	Fractions
9	Not Met	Math	Decimals
10	Met	Math	Fractions
10	Met	Math	Decimals
11	Met	Math	Fractions
11	Met	Math	Decimals
12	Met	Math	Fractions
12	Not Met	Math	Decimals

[lbendlin · Accepted solution]

[afaherty]

Beautiful, thank you!! (I also like the filename "ah the seventies" - made me laugh!)