Vizlib Home
Welcome
Login

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.

Login to post a comment