How to suppress null values in pivot tables

If you have a pivot table that is showing blank fields (rows), use this formula to set those blanks to null:

 =IF(ISNULL(fieldname), NULL(), fieldname)

then uncheck the "Include null values" box.