You can sort data on a data access page, including data that's grouped. For grouped data access pages, you can sort the list of groups or the records within a group.
Note When you sort records within a group, the sort order only applies to that group. It does not affect the order of records in other groups. For example, say a data access page is grouped by region, the region names are listed in ascending order, and under each region employees are listed in ascending order by their last name. If you display employee records for Mexico and then sort employees in descending order by last name, then the employee records for other regions will still be sorted in ascending order, as will the list of regions themselves.
Notes
This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be sorted independently from the rest of the data on the data access page, and may also support additional sorting capabilities. To display help for a PivotTable list, spreadsheet, or chart, click Help on its toolbar.