Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows to columns in a table or pivot table | Excel Discussion (Misc queries) | |||
How do I get a Pivot Table to repeat the values in the columns? | Excel Discussion (Misc queries) | |||
Too many rows or columns in pivot table | Excel Discussion (Misc queries) | |||
Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
Rows with zero values in Pivot table. | Excel Discussion (Misc queries) |