count pass/ fail in pivot table

[Anonymous]

I need to count the number of students under a specific major (ex: engineering degree, business degree) with a count of one fail grade for a specific semester, and then the number of students with a count of exactly 2 failed grades, 3 failed grades and so on.

[rubenmarin]

Hi Mohammed, please look expressions at attached file.

[hic]

You can also create a pivot table with the following dimension/measure:

Dimension: =Aggr(Count({$<PASS_FAIL={F}>} PASS_FAIL),People_ID)

Expression: Count(distinct People_ID)

Then you will get a table that classifies your students according to number of failed grades:

In other words: given the current selection, 63 people have failed one test, 40 have failed 2 tests, etc.

HIC

[Anonymous]

sorry but where is the attachment file ?

[Anonymous]

I will try this idea.

Regard.

[rubenmarin]

It's attached in my previous post: