Drag that calculation to the filters shelf and set to true.
I think you can achieve what you are looking for by putting "This Range" on the filter card and excluding "YES." But you might have to show empty columns/rows. If that's a problem you might want to create a calculated field that puts a "NO" in all null fields (IFNULL([This Range],"No")). That way you could filter and choose null.
Hope that helps,
Thanks guys. That solved it.
one more question. i have my date set to weekly. The header shows Week 32, etc. How can you get the actual date to show?