Working with Data Tables

This section describes the various options and settings you can make when working with data tables.

• To change the column order in a data table, drag a column head to the desired position and drop it. Column and row headings remain visible when scrolling.
• To restore the original column order if columns have been moved (reordered), right-click anywhere in the table and select Reset.
• To add a new set of data to the table each time an analysis runs, right-click anywhere in the table and select Accumulate.
• To add a note to the data table, right-click anywhere in the table, select Add Note, and type the note text in the resulting dialog box. Once created, you can edit the note’s font, background and border colors and visibility, and the border width.

The following tabs appear in both the Properties window and Properties dialog box for the data table.

Data Table Tab

• Show Global Min-Max – Displays the global minimum and maximum values of the unfiltered data values in each column (or row if the table has been transposed). These values appear at the beginning of the table.
• Show Local Min-Max – This field appears only if you choose to specify minimum and maximum values on the Data Filter tab. Displays the local minimum and maximum values of the data values in each column (or row if the table has been transposed). These values appear at the beginning of the table.
• Transpose – Rearranges the data table such that each column of data becomes a row. Column and row headings remain visible when scrolling.
• Num Data Per Page – Sets the number of rows of data displayed per page. When multiple pages are available for viewing, use the arrows and page numbers at the bottom of the table to navigate through the pages.
• Goto Page – This field appears only if multiple pages of data are present. Click to open the Goto Page dialog box where you can choose the desired data page.
• Show Trace Name – This check box toggles display of all trace names.
• Show Solution Name – This check box toggles display of all solution names.
• Show Variation Key – This check box toggles display of all variation key names.
• Font – Opens the Font dialog box in which you can set the font characteristics for the table.
• Back Color – Sets the table background color.
• Border Color – Sets the table border color.
• Border Width – Sets the table border width.
• Grid Color – Sets the table grid line color.
• Grid Line Width – Sets the table grid line width.

Data Filter Tab

You can filter table data via the Properties window Data Filter tab which can be opened by selecting any table column. (The Data Filter tab is also available in the table Properties dialog box; double-click any column heading.) You can also set table units and formatting on the Data Filter tab.

The following settings are available:

• Units – Sets the unit of measure for the selected field.
• Number Format – Sets whether the data in the selected field displays in decimal or scientific notation.
• Field Width – Sets the total number of digits displayed for the data in the selected field.
• Field Precision – Sets the number of digits displayed to the right of the decimal point for the data in the selected field.
• Specify Min and Specify Max – When selected, lets you set the Min and/or Max data values of the selected field to be included in the filtered list of data.
• Pare to – Filters the data table on the selected field using Pare to Minimum, Maximum, or user-specified Pare To Value.

Header Tab

• Title Font – Opens the Font dialog box in which you can set the font characteristics for the table title.
• Sub Title Font – Opens the Font dialog box in which you can set the font characteristics for the table subtitle.
• Company Name – Field in which you can enter text for the subtitle.
• Design Name – Toggles display of the design name in the table header.