Sort View Table

The Sort View table on the Contract View tab displays the schedule variance (SV), cost variance (CV), and variance at completion (VAC), by contract and element, at any level of the selected structure (the work breakdown structure, for example).

Table Format

The Sort View table is a straight (non-pivot) table. You can double-click any column heading to sort the rows based on the values in that column. You can also drag columns to a new location to change their order.

Table Data

The Sort View table displays variance values for the selected contracts as of the period selected in Period. In addition, it displays performance and trend indicator columns for each variance type.

Column	Description
Contract	This column displays the currently selected contracts. To focus your analysis, you can select one or any set of contracts. To select a set of contracts that are listed together, click and drag to make the selection. To select multiple contracts that are not all listed together, click at the right end of the column heading to display a list of the contracts, and press and hold the CTRL key as you click each contract.
Structure elements	By default, this column displays all elements in the top level of the selected structure (the WBS, for example) for each contract. To display elements for a lower level, right-click next to the column name and select the level. To focus your analysis, you can select one or any set of elements. To select a set of elements that are listed together, click and drag to make the selection. To select multiple elements that are not all listed together, click at the right end of the column heading to display a list of the elements, and press and hold the CTRL key as you click each element. Whether or not indirect costs and management reserve are displayed in the grid is based on your selection in Exclude Indirect under Data Options.
SV, CV, VAC (colored cells)	These performance indicator columns display color-coded performance and trend information based on the selected period for schedule variance, cost variance, and variance at completion, respectively. The colors and arrows are determined by the change threshold settings that your wInsight system administrator establishes for each contract in wInsight. The colors indicate current or cumulative performance based on the thresholds, and the arrows indicate if that performance represents a significant positive or negative trend, compared to the prior period.
SV	This column displays either the schedule variance amount or schedule variance percentage for each element. To filter for specific values, click in the column heading and, between the asterisks in the search box, type one or more characters that those values contain. You can also filter for values using <, >, or = (>0 for example). For this type of filter, be sure to delete the asterisks from the search box.
CV	This column displays either the cost variance amount or cost variance percentage for each element. To filter for specific values, click in the column heading and, between the asterisks in the search box, type one or more characters that those values contain. You can also filter for values using <, >, or = (>0 for example). For this type of filter, be sure to delete the asterisks from the search box.
VAC	This column displays either the variance at completion amount or variance at completion percentage for each element. To filter for specific values, click in the column heading and, between the asterisks in the search box, type one or more characters that those values contain. You can also filter for values using <, >, or = (>0 for example). For this type of filter, be sure to delete the asterisks from the search box.