Showing the percentage of totals

Seeing the percentage of each group as compared to the total of all groups is as useful as seeing totals and breakdowns. This gives the reader an idea about the magnitude of every value compared to that of the totals. Tableau offers various options to see values as percentages of the totals. These options include seeing percentages of the row totals, the column totals, or the grand total.

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 see percentage values:

  1. Drag-and-drop Product Type from Dimensions in the Columns shelf.

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.