Forum Discussion
Helper IHelp with filtering first 10 records in table
This is happening because your column unidades has duplicate values. I suggest you to create an Id column and then apply the Top/Bottom N filter. It works for me as shown below:
Helper IHi Anonymous.
In the end I was able to solve it by doing the following.
1. I defined the sorting in the table by the column type
2. I created a new column called index
3. Then I created an auto numeric measure based on the records shown in the table (in case there are filters).
4. With the new measure I have filtered to show me the first 10 records.
With these changes, I have managed to filter the first 10 records taking into account the column type
The problem I have now is that if I do not add the "Index" column, the system does not apply correctly the sorting by rownum column.