You can improve aggregate view performance by using the sorted input option in the aggregate view editor. When you use sorted input, Data Validation Option assumes that data is sorted by group. Data Validation Option performs aggregate calculations as it reads rows for a group. To use the
Already Sorted Input
option, you must pass sorted data to the aggregate view. If the records in the data source are not sorted, tests might fail.