About the Functions of Trellis Views

For the most part, a trellis view behaves like a pivot table. The main difference between a trellis and a pivot table is the way the data cells are displayed.

In the row and column label cells of a trellis, you can:

• Right-click to hide or move measure labels.

• Right-click to sort data.

• Drag to reposition rows and columns.

In the data cells of a trellis, you can hover the mouse pointer to display related contextual information. Numeric data cells in a trellis behave the same as numeric data cells in a pivot table. The ways in which the behavior of a trellis view differs from the behavior of a pivot table are the following:

• Graph data cells —  There is no right-click functionality for the data cells in simple trellises, nor drilling in trellis graph data cells (left-click functionality).

• Microchart data cells —  When you hover the cursor over the data cells in spark graphs, you’re shown contextual information (such as first, last, minimum, and maximum values) that otherwise isn’t displayed as it’s in a pivot table view.