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.
- On the Home page, hover over a workbook, click Actions, and then select Open.
- Click Edit.
- In the workbook, select a table or pivot visualization.
- Click Properties. In Properties, click Totals
.
- Set Grand Total to On.
- In the Label row, click Auto, and then click Custom.
- Enter a custom display name for the grand total, for example, Revenue Total.
- Click Save.