| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
suppresssing zero in pivot table
How can I suppress zero data rows in the new 2007 pivot tables?
Thanks, Mike |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
suppresssing zero in pivot table
Use a Value Filter in the Row Labels area:
Click the dropdown arrow on the Row Labels cell If there are multiple fields in the Row Labels area, select the field you want to filter for zero Click Value Filters, and then click Does Not Equal Type a zero, and then click OK Mike wrote: How can I suppress zero data rows in the new 2007 pivot tables? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
| pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Hybrid Mode
