Reporting issue using Sorting AND Rows limit

[LAFONTA91 (pyl)]

Hello community

I’m building a security report for my management with a “TOP TEN” element.

I’m use the sorting function with a performance data value 1. Report is OK

I’m adding a limit row to 10 and it gone wrong: The result is limited to 10, but report content is wrong!
Sorting is correct in a way that each element is ordered ascending as defined, but there is missing element ( it’s not top ten, it’s number 1, 5, 6, 9, 14,17,18,22 25,30 ) …

I suspect a wrong query / logic indeed.

How could i bypass this problem ?
Im using 2.0.0p6.cee edition

[LAFONTA91 (pyl)]

Some detail and screenshot if that could help:

It’s “A multisite View” content element (datasource: All service)
I have about 60 asset in the view.
If I limit rows to 100, no problem: the sorting is ok.
if I limit to 10 rows for only get TOP TEN… i dont get the real top ten, but … aleat of my list ( even ordered)