Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgonin
Contributor II
Contributor II

Hide column filled only with nulls

Hello dears!

Please tell me how to hide a column in pivot table which has only zeros (nulls) - see example below. I know about unchecking button "include zero values" and "include null values". Normally, if I have only one measure, it works correctly, but I have to add one more measure (which has a lot of null values for prior months). 

In this particular case I want to hide month "2018-01" in measure "LM growth"

 

Capture.PNG

 
Labels (1)
1 Reply
Anna_Klimkova
Employee
Employee

You can't hide this month because you have values (not null) for month "2018-01" in the first measure Sum .