remove lines in pivot table with zero values

B

barbara cervantes

click on last column in pivot table on screen; you will see sort
options, clear filter, label filters, value filters. The "value
filters" is the one to click on and you will see more menu choices
such as: clear filter, greater than, does not equal, less than, etc.
Chose the "does not equal" and on next screen input the 0.00. That
will make all the lines with the 0.00 become hidden.
 

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