Count dimension in pivot table

[Anonymous]

Hi all please help me to count the failure student like the requirements in image. and sorry for bad english

Example: (Pivot Table)

Student ID      Curriculum      Pass/Fail

S0001             C1654             Fail

S0001             C6549             Fail

S0002             C9875             Fail  

S0003             C5498             Fail

S0003             C6545             Fail

S0003             C5465             Fail

S0004             C2465             Fail      

the requirement in picture:

[MK_QSL]

Provide sample data for this!

[ecolomer]

Can you explain more, please?

[sunny_talwar]

Like the people before me has mentioned, we would need more details to help you resolve your issue. What is your dimension in the above chart and can you provide the sample data with its expected output?

HTH

Best,

Sunny

[petter]

I think Count() wrapped in an Aggr() should work well for this scenario: