Display or Hide Grid Subtotals

You can display or hide subtotals in a grid.

1. While viewing or editing the dashboard, select the grid visualization to add subtotals to.
2. To display subtotals, right-click the metric and select Show Totals.
3. To subtotal an attribute, right-click the attribute to its right, point to Show Totals, and select the function such as Total or Average. You can select multiple functions. Click OK.

   • For example, the grid shown below displays the totals for each airline-airport combination. This was accomplished by right-clicking Year to subtotal. To display the totals for each airline, right-click Departure Airport. To display grand totals, right-click Airline Name.

     

   • In a modern grid, you can total the rows and/or the columns. For example, the modern grid shown below displays the totals for Airline Name (rows) across the top of the grid. The average for Departure Airport (columns) is shown as a separate column set on the right.

     

   • In a modern grid with microcharts, the total displays as the microchart. For example, the sparkline for Flights Delayed by Day of Week and the trend bars for Flights Delayed by Airport are totaled in the following grid:

     

(missing or bad snippet)

4. To hide all subtotals, right-click a metric and clear Show Totals.

   If a custom subtotal has been defined and displayed by the dashboard author, it is hidden as well. You cannot redisplay the custom subtotal.

5. To hide a specific subtotal, right-click the subtotal label and select Remove.

   You can hide a custom subtotal but you cannot redisplay it.

6. To hide multiple subtotals, right-click the attribute, point to Show Totals, and clear the check boxes for the specific functions. Click OK.