What are the Functions of a Trellis View

This is a short description.

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

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

  • Right-click to do things like create groups and calculated items

  • 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 show 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 are shown contextual information (such as first, last, minimum, and maximum values) that otherwise is not displayed as it would be in a pivot table view.

    Microcharts do not show axis labels, as regular charts do, so it is not immediately obvious what the inner graph dimensionality is. Use a microchart's tooltips to understand the data being represented inside the graph—sample individual values, as well as the overall dimensionality.