In version 9.2, the aggregate T/F calculation 2 will work on the filter shelf. In earlier versions, you can't add this calc to the filter shelf, but you can HIDE the unwanted values. In the attached book, I have hidden the marks that return false.
To unhide the 'false' marks, right click the AGG(2) pill that is driving the color and click 'Show Hidden Data'. Workbook is version 9.0.
laphorn example.twbx 510.5 KB
Thanks Tom, that's helped.
Previously, I was getting an actual error message when trying to add to the filter (I'm using 9.2) . I created a new sheet and that seemed to fix it.
Thanks a lot.