Pivot table count on condition

[userid128223]

I have following kind of table

School	Subject	Students	Grades
ABC	Math	ab	0
ABC	Math	ac	12
ABC	Math	ad	32
ABD	Math	ae	1
BB	English	uu	44
BB	English	ud	0
BB	English	ua	33

I want to create pivot table like below

School	Subject	Count with Grades > 0	Count with all grades
ABC	Math	3	4
BB	English	2	3

How can i achive above pivot tables.

[prat1507 · Accepted solution]

Hi

PFA the .qvw for your reference.

Regards

Pratyush

[jonathandienst]

Simple set expression:

=Count({<Grades = {">0"}>} Students)

[userid128223]

Thanks to both of you.

Another quick question. In my pivot i am getting counts correctly however i have some blank data which is also getting count and i want to keep it that way. However i was wondering if i can label empty field as "BLANKS"

[prat1507]

Just add to your dimension where you're getting blank as if(Dimension='','BLANKS',Dimension)