@Dan_Rose @shishir thank you very much for those ideas, i’ve had the problem of limiting results from filter for at least the past year, game changer! 
@Tiago_Melo i’ve figured out that the best way (in terms of practicality and not speed or performance) is to filter using an intermediate table, what i mean is that you filter and sort the original table, then you just use the Danyliuk Method (thanks to the legendary @Paul_Danyliuk) and in a new column in a new table you write [yourtable], this will create a link to your existing, sorted & filtered table, then you simply add “.slice(x,y)” to that formula and you’re done!
P.s. that’s actually what i’ve just done, it works flawlessy 
Let me know if that help! 