How to Workout Percentage of Total in Tableau

🆘 Need More Help? 📧 Email Rbreen@ynteractive.com

Subscribe: http://bit.ly/3i3WN4p How to Workout Percentage of Total in Tableau

In this example I have category subcategory sum of sales and the percentage of total for each record. It sums up for all subcategories right now.

I've added a new sheet with sales category and subcategory. Let's find the percentage of total.
Whenever you're doing percentage of total make sure to add the grand total and click on analysis totals and add subtotals as well.

it's going to help you understand the table calculation and get the right answer. I have sum of sales on text already. I can drag a copy of some of the sales onto detail first and then I'm going to modify that.

I'm going to use a quick table calculation by clicking the drop down on sum of sales quick table calculation and selecting percentage of total. Now if I drag that to the center of the view where it says show me I'm going to get measure names and measure values. Let's bring that to the bottom and you can see I have percentage of total it adds up to 100 for each unique furniture and subcategory record.

I can edit that because it's a table calculation to be indexed differently maybe I want the percentage of total to be for each category. a table calculation in order to make it calculate for each category all you have to do is click on specific dimensions and unchecked category. Now you can see these four records add up to 100. You can see that with a subtotal and these records here add up to 100 which is the percentage of total for office supplies only.

Видео How to Workout Percentage of Total in Tableau канала Ynteractive Training