ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   remove lines in pivot table with zero values (https://www.excelbanter.com/excel-discussion-misc-queries/270599-remove-lines-pivot-table-zero-values.html)

barbara cervantes

remove lines in pivot table with zero values
 
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.


All times are GMT +1. The time now is 08:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com