Summary History View

When you define IDs and codes, it is important for you to know how they appear in a field list after they are sorted. TRAVERSE sorts alphanumeric data alphabetically by comparing first characters, then second characters, and so forth. When two alphanumeric characters are compared, the character with the smaller ASCII value comes first in the alphabetic sort.

The list of alphanumeric characters is in ascending alphabetic order:

• Special characters (-, *, /, and so forth)
• Numbers (0-9)
• Uppercase letters (A-Z)
• Lowercase letters (a-z)

Alphabetical rules are not intuitive when numbers are involved. For example, in numerical sorting 60 comes before 112; however, in alphabetical sorting 112 comes before 60. To ensure that numbers appear in the same order in both an alphabetic and numeric sort, pad numbers to the left with zeros until they are the same length. For example, if 60 is defined as 060, 060 comes before 112 in both an alphabetic and a numeric sort.

Sort	By
Ascending	Clicking the row or column heading until the appears
Descending	Clicking the row or column heading until the appears

You can sort rows and columns to group and filter the data. To sort and filter the rows and columns, right-click a column and use the functions outlined in the table below.

Button	Name	Select To
	Refresh Data	Refresh the data in the table and graph.
	Hide	Not use the selected field in the table or graph.
	Order	Toggle the order of fields if multiple fields exist in a single section.
	Show/Hide Field List	Open the PivotGrid Field List window. Proceed to click and drag fields from this window to use them as part of the graph or drag fields to this window to remove them from the graph. Note: You can also accomplish this task by clicking on the heading of the field to remove and drag the heading to the bottom of the screen and release once your cursor changes to a large 'X'.

1. Click the funnel icon that appears once you place the cursor in the desired row or column to filter.
2. Select a filter option from the drop-down menu.
   Note: From this drop-down list, you can select whether to Show All entries or select from the entries in the selected row/column to view only the selected entries' information in the row/column.
3. Click OK.
   

To create a filter across all rows or columns, use the Prefilter function to create a filtering condition. A filter condition can consist of up to four options. Each option within the condition appears as a different color to help distinguish it from the other options, Red Text [Blue Text] Green Text <gray text>. The instructions below illustrate how to build a condition.

1. Select how to group values by clicking the red text component (See Table 1).
2. Select a column heading to filter by clicking the blue text component.
3. Select the filtering criterion by clicking the green text component (See Table 2).
4. Enter, if applicable, a string of text or numbers to complete the condition by clicking the gray text component.
5. Click Apply.
6. Click OK.
   

Button	Name
	And
	Or
	Not And
	Not Or
	Add Condition
	Add Group
	Clear All
Table 1 - Red Component
Button	Name
	Equals
	Does not equal
	Is greater than
	Is greater than or equal to
	Is less than
	Is less than or equal to
	Is between
	Is not between
	Contains
	Does not contain
	Begins with
	Ends with
	Is like
	Is not like
	Is blank
	Is not blank
	Is any of
	Is none of
Table 2 - Green Component