Tableau Desktop Certified Associate: Exam Guide

Example 1 – contribution to total

Using the Global Superstore dataset, we want to show contributions to total profit for the South region of the EU market, slicing by country, category, and subcategory. What is the contribution of the Fasteners subcategory in Italy to the overall Fasteners business in the South?

We can first plot profit by Country and Sub-category in the South, adding totals:

In the case of Fasteners in Italy, we want to see that it represents $578/$898 = 64% of the profit.

We have two ways of calculating that contribution. We can add a quick table calculation for Percent of Total for SUM(Profit), with computation along