Is there a way to exclude null values for pivoted table calculation column?

For example i have data for 2019 and 2020 i wanted to calculate variance i get null for 2019 Variance due to data missing or not available to compare. I wanted to hide or remove this null column when I do that it hides variance for 2020 as well from visualization.

1 1 1,435
1 REPLY 1
Top Labels in this Space