Exclude zero values from pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am trying to summarize items in various warehouses. My list
ncludes all items, even though they may only show up in one
warehouse out of several. I have a pivot table report, but it
lists all the items and I only want those with a value greater than
zero. For example:
Warehouse 1 - item 123 quantity of 2
item 234, quantity of 0
I only want item 123 to show.

thank you.
 
Back
Top