Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Surpressing rows and columns with zero values in a pivot table
Your issue is that it has a value. Something adding up to zero is just as
valid as something adding up to any other number. The pivot table makes no distinction. I am assuming that you do not have show all members turned on. By default it is not turned on. What does your source data look like and do you have the ability to suppress the zeros value employees prior to creating the pivot table? FYI other cube programs such as Essbase do have the abiltiy to suppress missing and or zero values but that does not help you in your pivot table... -- HTH... Jim Thomlinson "Jack" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |