How to use multiple filter scheme in data function

I have a data table, say: ID, Name, State, Gender and 2 filter schemes : State is with filter scheme 1 and Gender is with filter scheme 2

For the table, I can limit data using both filter schemes at the same time.

I create a data function with the input is the data table, and output is a subset of the data table, depending on whatever filters selected.

However, data function input parameter does not allow to select both filter schemes: i.e. either scheme 1 or scheme 2.

So let say if I limit data in data function using scheme 1 then whatever users select Gender for filter, input data to data function is only limited by state.

Attached is the demo. 

Any suggest to overcome this?

 

 

Attachments

AttachmentSize
Binary Data example.dxp646.77 KB
Login