Access to 130 free guest articles, discussions and more, just create your free OfficeUsers User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Excel: Hide zero value lines within a pivot table

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

See Related Articles

Article Abstract:

Question: I wonder if you can help, is there a way in which you are able to hide zero valued lines within a pivot table ? i.e. I have a table with two columns branch name and stock value and I would like to hide the branches with no value against them - is this possible?

Read this article...

Related Articles - For Members.

	Introduction To Pivot Tables
	What Is a Pivot Table
	Pivot Table Parameters
	Add a pivot chart to your Access reports
	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS
	Microsoft Excel Pivot Tables
	Business Intelligence in Excel 2007
	Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
	Restructure Excel worksheet information for better analysis with PivotTables

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback

[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2008, Bits on the Wire, Inc.

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.