user21
user21

Reputation: 249

How calculate additional column with percentage to the total in Tableau?

I could create something like pivot table for my statistic. Here is an example:

enter image description here

But I need to add statistic like in this table:

enter image description here

Here is a link to data: Data for the Question

How calculate additional column with percentage to the total and total percentage as separate column to the pivot table in Tableau?

Upvotes: 0

Views: 4495

Answers (1)

Jose Cherian
Jose Cherian

Reputation: 7707

Your data look different from your screenshot. But generally you can use a table calculation to achieve this. enter image description here

Right click on the measure you want to add table calculation and select "Add Table calculation". Make sure that calculation type is "Percent of Total " and Compute using is "Table(Down)".

enter image description here enter image description here

Upvotes: 3

Related Questions