Hi Dylan, Sorry for the delayed response.
The below link has sample images from the previous use case.
Problem I am trying to solve: Lets say i have 100 tickets, each ticket is in a different stage. Now when I report, I would like to show the value as Sum of that stage plus all the stages after that and repeat the same for successive stages. This would help me end up with a waterfall table, which shows cumulative numbers.
To achieve this, I created 5 calculated fields for each stage using “ifelse” that would give me either the stage value or null. This would mean that the calculated field would have high null values as we move down the stages, considering we will only be showing the last bucket of the staging alone.
Now when i add these 5 calculated fields one after another into the pivot, the group by logic shows blank values as expected. However we cannot filter out null values, since there will be data for the previous stage which needs to be reported.
Temporary Solve I found: I have sorted the values descending, which pushes the blank values to the bottom of the pivot. Once this is done, I change the font & background coloring for cell/header to be the same in order to not allow users to be able to read the value. However those blank cells will continue to show up on pivot and users when they click on the blank cells will be able to read the value.
If there is a way to hide specific cells it would be great 
or if there was a different calculated field model to be used, it would have sorted this issue.