Pivot : Don't Show Part of Field If Data Blank/Empty

[muhammad susanto]

hi all..
i have 2 pivot table with single data set..
name of pivot 1 and pivot 2..if in Pivot 2 in name "Frans" is empty data/blank.
how to hidden or don't show name Frans in Pivot 2 if data empy/blank.
this capture picture for easy understanding
thank for help me.
.sst

 

[mart37]

Maybe with a value filter >0

 

[muhammad susanto]

Maybe with a value filter >0

hi sorry, not fully work..
if i have use Slicer, then Select all field then select again one of field, your tricks not working again..
i mean, when use Slicer (Filter) for one field or all field the result is consistent.

 

[muhammad susanto]

Maybe with a value filter >0

Hi.... Have somebody idea or solution?

 

[muhammad susanto]

maybe someone how to show use Power Query to figure out this?