Hello,
I am using ODX server 20.10.47. I would like to limit the amount of records loaded by implementing following filtering rule on column perakt] among others:
LEFT ((perakt],2) > 20
I am trying to achieve this in following way using “Filter Rows” options on data source but it does not work:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/2c1a4468-33dd-483e-9f4c-bb6242bb7050.png)
Also if i click OK and load the data, the 2 upper filters are not applied, just because the 3rd filter does not work.
Are there any ways of achieving this through “Filter rows” functionality? Or the only option is to create a custom query table?
Thank you!