Empty table customize

I am trying to put a filter on Payment received column ‘Y/N’ and I am extracting all the N’s in the excel.

If I apply column filter for ‘N’ it will create a empty table (that means i do not have any default) - when extracting this in excel I need the empty table to say “100%” compliance on the excel sheet

How to do this?