software

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: www.excelforum.com/member.php...oamp;userid=32805
View this thread: www.excelforum.com/showthread...hreadid=526227Maybe you could use a helper column:

=if(a2=0,0,1)

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

janssenchoy wrote:
gt;
gt; Is there some way to get a pivottable to display a count of all non-zero
gt; entries? I'd want to use a pivottable over subtotaling or a combination
gt; of sorting and counta, due to the amount of categories I have to split
gt; items into (~approx 200).
gt;
gt; --
gt; janssenchoy
gt; ------------------------------------------------------------------------
gt; janssenchoy's Profile: www.excelforum.com/member.php...oamp;userid=32805
gt; View this thread: www.excelforum.com/showthread...hreadid=526227

--

Dave Peterson