Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

Pivot Table SubTotals

In excel 2003 I have a pivot table that I have filtered out to get the
information that I need to see. However when I use the sum function for a
column (company Name) the subtotals still show some of the company names that
I have filtered out. Does anyone know how to get rid of the names without a
value?

THX..

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table subtotals	Matt M HMS	Excel Discussion (Misc queries)	1	June 3rd 06 01:40 AM
Pivot table subtotals	RhysPieces	Excel Discussion (Misc queries)	2	May 4th 06 04:58 PM
Pivot Table Subtotals	vcurban	Excel Discussion (Misc queries)	4	March 2nd 06 01:03 AM
pivot table row subtotals	david	Excel Discussion (Misc queries)	2	June 29th 05 11:09 PM
Pivot table subtotals 100%	JaniceHill	Excel Discussion (Misc queries)	0	December 16th 04 02:43 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us