The expressions count by the first dimesions in pivot table

[jixiaoquan]

Hi everyone,

    There are two expressions and two dimensions in a pivot table.

     The first dimension is Department and the second dimension is Class.

     The first expressions is "count(distinct StudentID)" the result is count students of every class.

     Now I want the second expression is count students of the Department,how to do ?

     Thank you!

[Gysbert_Wassenaar · Accepted solution]

Try count(distinct total <Department> StudentID)

[MK_QSL]

COUNT(Distinct TOTAL <Department> StudentID)

🙂 Gysbert has already answered !!!

[jixiaoquan]

Thank you Manish  Kachhia!