Change "0" value to "-" in Pivot Table and Delete Row where all value is Zero (0)

[Zaidan_as]

Hello guys, 

Introduction:
In my pivot table, i'm showing value or count of the outstanding tickets. 
This is my pivot table 

Outstanding tickets are count with this formula :
if([Status]='Open',1,if([Status]='Pending',1,if([Status]='Waiting on End user',1))) as [OutstandingCount]

Problems :
1. As you can see in period 2021-Sep and 2021-Oct, the value is all zero. what I want to change is "0" to "-"

2. Then if you see in this illustration when 2021-Sep is drilled down to the 2nd dimension, I want to delete all rows because the value is Zero (0)  

Is there any way to do these 

[Zaidan_as · Accepted solution]

Ok guys, i already found the solution.

Those problems happen because the way I picked the wrong way to show the value.
So right now, instead I'm making new column using this code in load editor  :
if([Status]='Open',1,if([Status]='Pending',1,if([Status]='Waiting on End user',1))) as [OutstandingCount]

Now I don't need to make new column, and I just make this set analysis in the pivot measure expression :
=Count({<[Status]={'Open'}>+<[Status]={'Pending'}>+<[Status]={'Waiting on End user'}>}[ID])