Removing '0' values in a pivot table
 

I know i've seen this Q&A before, but i can't remember how.
i want to remove lines with a '0' value from my pivot table.

--
Browny

Removing '0' values in a pivot table
 

Filter out 0s.

If you just want to suppress the use CUSTOM number format

##.##;(##.##);;

Adjust ## according to your need.

"Browny" wrote:

I know i've seen this Q&A before, but i can't remember how.
i want to remove lines with a '0' value from my pivot table.

--
Browny

Removing '0' values in a pivot table
 

Try right-click inside the pivot Table Options
Check "For empty cells, show:" <nothing (Leave it blank)
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"Browny" wrote:
I know i've seen this Q&A before, but i can't remember how.
i want to remove lines with a '0' value from my pivot table.

--
Browny