Pivottable to count non-zeros

J

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).
 
D

Dave Peterson

Maybe you could use a helper column:

=if(a2=0,0,1)

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