Data and Other Records

groggrog

Guest

Posts: n/a

20th Sep 2005

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

« Dynamically changing Border-Color of all series() to "0" | chart data series -- plot a table as a single series »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete records when certain records have duplicate column data	JVroom	Microsoft Excel New Users	0	26th Jan 2009 05:07 PM
Compare New Records fields (50+) to old/existing records data fiel	=?Utf-8?B?SmVu?=	Microsoft Access VBA Modules	1	12th May 2006 04:02 AM
code to get records does not return the same records as a direct qyery on the data	Savvoulidis Iordanis	Microsoft Access Form Coding	5	14th Mar 2005 08:03 PM
Need to filter all records that meet Data Validation List - list many records for one selection	Cheryl	Microsoft Excel Discussion	3	5th May 2004 09:21 PM
Continuous Form - new records overwrite data in existing records	Pat	Microsoft Access Forms	1	3rd Sep 2003 05:57 PM