Create Custom Labels for Grand Totals in Tables and Pivots

You can customize a visualization grand total label in tables and pivots by entering your own text.

For pivot visualizations, you can customize the grand total labels for both rows and columns.
  1. On the Home page, hover over a workbook, click Actions, and then select Open.
  2. Click Edit.
  3. In the workbook, select a table or pivot visualization.
  4. Click Properties. In Properties, click Totals Totals icon.
  5. Set Grand Total to On.
  6. In the Label row, click Auto, and then click Custom.
  7. Enter a custom display name for the grand total, for example, Revenue Total.
  8. Click Save.