In current situation, OutSystems Platform only allows limiting the max records which are obtained (LIMIT / TOP). It is not optimized to allow primitives such as OFFSET to be included.
For this reason, it require huge time to fetch data from database using Aggregate. If OFFSET inplemented. it allows to do more faster data processing can do through Aggregate.