LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 186
Default Surpressing rows and columns with zero values in a pivot table

Let's say I want a report showing the number of times that my employees,
grouped in offices, markets and regions, makes a particular kind of error.
At the end of the month, I'd like to create a pivot table that says, "This
office had this number of errors of this type." I can create a pivot table
that does that, but it includes all the employees that have zero errors,
making the report unwieldy.

How can I format the pivot table to hide any row or column that has no value
in it?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Rows to columns in a table or pivot table Jesper Audi Excel Discussion (Misc queries) 4 November 3rd 09 07:00 PM
How do I get a Pivot Table to repeat the values in the columns? Sunshine76 Excel Discussion (Misc queries) 4 March 20th 09 10:25 PM
Too many rows or columns in pivot table koneil Excel Discussion (Misc queries) 0 December 16th 07 10:48 AM
Too many rows or columns in my pivot-table markus Excel Discussion (Misc queries) 1 August 14th 06 02:58 PM
Rows with zero values in Pivot table. johnE Excel Discussion (Misc queries) 0 December 12th 05 07:34 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"