Customize/ Hide data in pivot table

=?Utf-8?B?QW5ndXM=?=

Guest

Posts: n/a

14th Jun 2007

I have a pivot table in following layout:

Status(firm order/ forecast) (column field)
firm order (column) Forecast order
(column)
Product (row field) Sum of QTY Sum of Order Sum of QTY Sum of Order
(data)

I want to show per product, the sum of qty and sum of order for firm order;
and sum of qty BUT NOT sum of order for forecast order (as all of them are
zero).

How to make it? or any code I can use?

« protect unprotect sheet vba | Export to MS Access »

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
I want to hide data that's less than 1 in a pivot table	SDixon578	Microsoft Excel Misc	0	23rd Apr 2008 01:09 PM
Customize/ Hide data in pivot table	=?Utf-8?B?QW5ndXM=?=	Microsoft Excel Discussion	0	14th Jun 2007 05:13 AM
Pivot Table - hide if no data	=?Utf-8?B?U3VzYW5KYW5lIHNqbA==?=	Microsoft Excel Misc	2	16th Sep 2006 01:19 AM
Hide data in pivot table?	Alan	Microsoft Excel Discussion	4	18th May 2006 11:30 PM
Pivot Table Customize functions in the Data Field	=?Utf-8?B?UFNLZWxsaWdhbg==?=	Microsoft Excel Misc	2	4th Jan 2005 06:51 PM