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


--
janssenchoy
------------------------------------------------------------------------
janssenchoy's Profile: http://www.excelforum.com/member.php...o&userid=32805
View this thread: http://www.excelforum.com/showthread...hreadid=526227