HELP - EXTRACT - ANALYZE

This option opens a form that allows you to filter and analyze the data in more depth.

A. TABLE COLUMNS = All the column headers from the table will be uploaded here. Click on any of the values to load the unique values for that column in the other list box (B).

B. UNIQUE VALUES = Displays all the unique values, their count, and their % as a total for the column selected in the table columns list (A). Double click on any value in this list to filter the data by that selection.

*You can only filter by (1) value at a time using this option so any previous filters will be cleared. Use the normal filter options for the table to use a multi-criteria filter.

C. LIST HEADERS = Click on unique values, count, percentage to sort the list (B) by that category. Click again to sort in reverse order.

D. CLEAR = Click to remove any existing filters in the table.

E. ALL = Exports all the unique values and their count for ALL of the table columns/headers to a new Excel workbook.

F. CURRENT = Exports all the unique values and their count for just the current selected table column in (A).

G. EXIT = Close the analyze form.

H. ? = Link to this help page for assistance.