MicroStrategy ONE

Add Subtotals to a Grid

  1. Click on the grid visualization you want to add subtotals to.
  2. In the Editor panel, right-click the attribute or metric for which you want to display subtotals.
  3. Select Show Totals.

    If you selected a metric, the corresponding totals appear at the bottom of the grid.

  4. If you want to move the subtotals at the top of the grid, right-click the subtotal label and choose Move to Top.
  5. If you want to move the subtotals back to the bottom of the grid, right-click the subtotal label and choose Move to Bottom.
  6. Click the Show Totals icon Show Totals Icon in the Editor panel to toggle between showing or hiding all subtotals.