Sort View Table
The Sort View table on the Master Dashboard tab displays the schedule variance (SV), cost variance (CV), and variance at completion (VAC), by element, for the selected level of the structure (the work breakdown structure, for example). To bring this table to the foreground, click the corresponding tab.
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 contract for all elements at the selected level of the structure hierarchy as of the period selected in Period. In addition, it displays performance and trend indicator columns for each variance type.
| Column | Description |
|---|---|
| Level | This column displays all elements in the selected structure (the WBS, for example) at the selected level of that structure. 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 the
CTRL key as you click each element. You can also select multiple elements in the
Unindented Elements list on the left side of the dashboard, and you can use that list to search for specific elements.
Click
Whether or not indirect costs and management reserve are displayed in the grid is based on your selection in Exclude Indirect under Data Options. If you select a parent element without children (or at least one child element), the three Bottom variance tables and three Top variance tables would not contain any data except for a message, informing you to select at least one lowest element for the rollup aggregation. |
| 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 cumulative or current performance based on the thresholds, and the arrows indicate if that performance represents a significant positive or negative trend, compared to the prior period. A legend at the bottom of the tab displays the thresholds. |
| SV | This column displays the cumulative or current schedule variance amount or schedule variance percentage for each element.
To filter for specific values, click
|
| CV | This column displays the cumulative or current cost variance amount or cost variance percentage for each element.
To filter for specific values, click
|
| VAC | This column displays either the variance at completion amount or variance at completion percentage for each element.
To filter for specific values, click
|
at the right end of the column heading to display a list of the elements, and press the
next to the first column heading to select the structure level for which you want to display variances: any of the first 5 levels of the structure, or the lowest level for each structure node.
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. When you use