Completely Remove (Blank) from Pivot Table

[Marmit424]

Hello,

I have a pivot table with a lot of (blanks). The data looks like this.
Level 1 || Level 2 || Level 3
Name1|| Name2 ||
Name1||

The pivot table looks like this:
Name1
(blank)
Name1
Name2

I would like for my user to be able to drill into the pivot table without seeing (blanks) to drill into. I also don't want them to see just an empty cell. I want it removed from the pivot table altogether. When I filter on remove value (blanks), it filters out everything in that level, including items that are not blank.

How can you completely remove (rather than 'hide') blanks from a pivot table?

Thanks!

 

[Marmit424]

Also, I have discovered if I make the pivot table in tabular form, I can filter the blanks without removing levels, however I consider this to be a messy solution. Doesn't look as clean.

 

[Marmit424]

Ignore the second post pls, it appears that is also wrong. Original question remains, thanks.

 

[Marmit424]

Bump