How to separate blanks and 0% in a pivot chart

In this example, the table tracks the sales forecasted revenue at the start of the month versus the sales actual revenue at the end of the month, it then applies a calculation to show the accuracy of the forecast in percentage format. There's a formula that specifies that if there is no forecast, put the forecast accuracy as blank. One of the forecasts returned no revenue, so the accuracy shows as 0%. Another one didn't have a forecast, so the accuracy is blank.

I want to create a pivot chart to show the forecast accuracy, but I have been unable to separate out blanks and 0%. I want the pivot chart to show blanks as blanks and 0% as 0%. one pivot chart that shows blanks as 0% and another that shows 0% as blanks, using the custom number format in the format data labels settings, I haven't found a way of creating a pivot chart that separate them out.

Working with me...

@rorya Just to let you know that I fixed the original sheet, not entirely sure what was wrong before but I won't question it. Thanks again for your help, reputation coming your way.