Exclude zero values from pivot table

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top