Showing totals
Although it is useful to show the breakdown of measures by various dimensions, readers value seeing grand totals for rows and columns. If at least one Columns or Rows value is present, it is very easy to show grand totals.
Getting ready
Let's use the sample file Sample – Coffee Chain (Access). Open a new worksheet and select Sample – Coffee Chain (Access) as the data source.
How to do it...
Once the data is loaded on the worksheet, perform the following steps to show grand totals:
- Drag-and-drop Product Type from Dimensions in the Columns shelf.
- Drag-and-drop Market from Dimensions in the Rows shelf.
- Drag-and-drop Profit from Measures in the Text box under the Marks pane.
- From the top menu bar, click on Analysis, expand Totals, and click ...
Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
