I would recommend checking out this thread.
You will need to restructure your filtering to work differently. Almost backwards, where you create a series of true/false columns in the data to be filtered. Then you can set your filters to look for all True values to determine if the row should be displayed.