Hi -

I'm building a pivot table consisting of counts of a list of items. I
want to include only the first 50 items in detail, but lump all the
others into an "other" category with a count on it, instead of detail
on records above 50.

Hopefully this makes some sense!

Thanks,

Greg.


--
groggrog
------------------------------------------------------------------------
groggrog's Profile: http://www.excelforum.com/member.php...o&userid=27400
View this thread: http://www.excelforum.com/showthread...hreadid=469155