It might be that the Data Type for your Pivot Field Value is set
to Decimal, which would turn text responses to null.
Maybe best to make a calculated field that converts
Yes/No to 1/0 and then put that in the Pivot instead.
Would recommend this resource:
And this example: