Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Haritha
Contributor
Contributor

How to hide a pivot table column when some of the values are NULL?

In the below qvf file 02/2020 is showing 2 null values. Please suggest how to hide 02/2020 ?

 

1 Reply
Or
MVP
MVP

Why would you hide this column? It has values in it...

If you don't want this to be displayed, write your formula(s) in a manner where all of the rows for this column value are 0 or null, and then hide 0/null rows.