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

Pivot Table briefly displaying null values

Hi all,

Hoping someone has seen this. I have a vizlib pivot table that we are suppressing nulls and zeroes, but when we first open the sheet, the suppressed values will show briefly, until you try to click on one of the rows that should be hidden and they disappear. Odd behavior that I am hoping someone has seen and has a solution for. 

Thanks!

1 Solution

Accepted Solutions
brucemwarren
Contributor
Contributor
Author

Found a solution. Seems like it gets confused when I had eliminated null value in Data, but left "Show Zero Values" checked in Data Handling. Unchecking fixed the issue. 

View solution in original post

1 Reply
brucemwarren
Contributor
Contributor
Author

Found a solution. Seems like it gets confused when I had eliminated null value in Data, but left "Show Zero Values" checked in Data Handling. Unchecking fixed the issue.