Percent of total in Tableau - Dashboard Guide

Dashboard Mode - Percent of total

Dashboard Goal

Understand how each product's sales contribute to the total sales in the store.

Sample Data

Product	Sales
Apples	100
Bananas	200
Cherries	300
Dates	400
Elderberries	500

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 1500
• Bar Chart: Sales by Product
  Shows sales values for each product from the data table.
• Bar Chart: Percent of Total Sales by Product
  Formula: SUM([Sales]) / TOTAL(SUM([Sales]))
  Result example for Apples: 100 / 1500 = 6.67%
• Table: Sales and Percent of Total
  Columns: Product, Sales, Percent of Total
  Percent of Total formula: SUM([Sales]) / TOTAL(SUM([Sales]))
  Shows each product's sales and its percent contribution to total sales.

Dashboard Layout

+----------------------+-----------------------------+
|      Total Sales      |      Sales by Product        |
|       (KPI Card)      |         (Bar Chart)          |
+----------------------+-----------------------------+
| Percent of Total Sales by Product (Bar Chart)          |
+--------------------------------------------------------+
| Sales and Percent of Total (Table)                      |
+--------------------------------------------------------+
    

Interactivity

Applying a filter on Product updates all components:

• Total Sales: recalculates sum for filtered products.
• Sales by Product Bar Chart: shows bars only for filtered products.
• Percent of Total Sales Bar Chart: recalculates percent based on filtered total.
• Sales and Percent of Total Table: shows filtered rows and recalculates percent.

Self Check

If you add a filter to show only Apples and Bananas, which components update and how?

• Total Sales: updates to 300 (100 + 200).
• Sales by Product Bar Chart: shows bars for Apples and Bananas only.
• Percent of Total Sales Bar Chart: recalculates percentages: Apples 33.33%, Bananas 66.67%.
• Sales and Percent of Total Table: shows only Apples and Bananas with updated percent of total.

Key Result

Dashboard shows sales by product and each product's percent contribution to total sales.