Have a filter on Service column thats says "is not null"
Use conditional formatting to turn the content font the same colour as the background when the value is null, but wouldn't it not add up then?
Sorry, I did not understand the question at first attempt. After seeing @Robert Angel 's answer , I read it again. You can do what Robert said, but that will show 1 empty line. Other option is using selection step to eliminate null Service value. More about that is here...
Why not correct the actual issue rather than pushing it under the carpet?
Solve the data quality issue in the source system?
Solve the data quality issue in the ETL?
Make the poor data quality visible by putting 'Invalid data' or 'Unassigned' for example?
Analytics should not have to cheat because the data is poor.
Selection step is a good idea - take population less one null value....
Have to side with Christian on sorting out the underlying data issues, or at least quarantining them until they can be resolved.