Thanks for getting back to me. Is there a way I can use a top N filter that does not use a field that is part of the datasource (the datasource is a web API that I cannot edit)? I tried setting up a filter on the table with:
Expression = RowNumber()
Operator = Rop N
Value = 5
However this returns an error saying "DataItem Filtering expression should not contain aggregate functions"
I can create an additional column on the table and use the RowNumber function, but the filters only allow you to use expressions or fields from the datasource, not columns that have been added to the table.