| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide zero totals in pivot table report
I have a file that I am importing that has warehouses across the top and the
inventory items down the side. Not every warehouse has every item. When I try to do a pivot table on the warehouse (part number in row area) I get EVERY inventory item, even those with zero values. Is there any way, excluding macros, to have the rows where the total inventory for that part number is zero not display? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) | |||
| Naming Pivot Table Paramater Report | Excel Discussion (Misc queries) | |||
| No Pivot Table Totals Wanted | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Threaded Mode
