How to change list filter from OR logic to AND logic by sql or ironpython

[devz powell]

In the filter shown above (List box filter or similar), bydefault when I select single or multiple values, my dashboard is updated with OR logic (Data coming from any of the selected country). How can I implement the following SQL to get suppliers from common in selected countries.

select distinct a.supplier

from invoices a

join invoices b on a.supplier = b.supplier

where a.country = 'France' and b.country = 'Belgium';

[Khushboo Rabadia]

This is not feasible. Values selected from a Filter are always with OR condition as you cannot have same multiple values in a row/column combination.

Filters operate on row values from that particular column.

[devz powell]

Agreed. I modified my question.