| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove non-exist values in pull-down list in pivot table | Excel Worksheet Functions | |||
| REMOVE CERTAIN LINES IN A PIVIOT TABLE | Excel Discussion (Misc queries) | |||
| how to remove old selection values in the pivot table | Excel Discussion (Misc queries) | |||
| How do I remove lines from a Pivot Table in Excel? | Charts and Charting in Excel | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
Linear Mode
