Pivottable to count non-zeros

[janssenchoy]

Is there some way to get a pivottable to display a count of all non-zero
entries? I'd want to use a pivottable over subtotaling or a combination
of sorting and counta, due to the amount of categories I have to split
items into (~approx 200).

 

[Dave Peterson]

Maybe you could use a helper column:

=if(a2=0,0,1)

and then include that in the pivottable as sum???