Sorting and filtering CrossTab report data
You can sort and filter data in a CrossTab report.
To sort CrossTab report data |  |
|
1.
|
|
Click a cell in a CrossTab report.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Sort and filter options. |
|
3.
|
|
In the Sort and filter dialog box, choose a field from the Field list box.
|
|
4.
|
|
In the Sort area, choose an option from each of the following list boxes:
|
|
•
|
Based on — lets you sort data based on the contents of a field or data field
|
|
•
|
Data field — lets you choose a data field from the CrossTab report
|
|
•
|
Sort order — lets you sort data in ascending or descending order
|
To filter CrossTab report data | |
|
1.
|
|
Click a cell in a CrossTab report.
|
|
2.
|
|
Click Tools
Data tools CrossTab Sort and filter options. |
|
3.
|
|
In the Sort and filter dialog box, choose a field from the Field list box.
|
|
4.
|
|
In the Filter area, choose an option from each of the following list boxes:
|
|
•
|
Display — lets you choose the items you want displayed after filtering
|
|
•
|
Based on — lets you choose a data field
|
|
5.
|
|
Type a value in the Quantity box to specify the number of rows available.
|