5 Replies Latest reply on Oct 8, 2018 5:37 PM by Ken Flerlage

# To find percentage of different measures in pie chart using filled map charts

Hi

Everyone,I have scenario where I have to show piecharts using filled

maps. I have used superstore dataset. I want to show percentage of sales and profit which are two different measures as shown . Is there a way to show how much percentage of sales and profit occupied in individual pie chart. As the measures are sync, Iam unable to sync the percentage of sales and profit using quick table calculation. It is showing individual percentage but i want to show percentage occupied in sales and profit in piechart by state

• ###### 1. Re: To find percentage of different measures in pie chart using filled map charts

Why would you show & of Sales and & of Profit in a pie chart? They don't have a part to whole relationship, so I'm not sure that makes much sense...

• ###### 2. Re: To find percentage of different measures in pie chart using filled map charts

Hi Ken,

Thank you, for the suggestion.

I know this scenario does not have any valid point.

But is there a way where i can show percentage relationship , if I took two different measures . As I am unable to find any percentage relationship between two measures.

Regards,

Dhritiman

• ###### 3. Re: To find percentage of different measures in pie chart using filled map charts

Create 3 calculated fields

1) Total >> Sales + Profit

2) Profit % = (sum(profit) / sum(Total)) * 100

3) Sales % = (sum(sales) / Sum(Total)) * 100

Filter the secondary axis with measure Names(Profit % & Sales %) and place the measure names in color shelf, and the measure values in angle shelf.

will it satisfy your requirement?

• ###### 4. Re: To find percentage of different measures in pie chart using filled map charts

But totaling sales and profit doesn't really make sense either. Sales would be the total amount of money you receive for the sales of a product (i.e. revenue), while profit is that same amount minus costs. You can't add them together. Rather, profit is a portion of sales. So, as I think about this, a pie chart might make sense, but what it should show is not % of Sales vs % of Profit but the % of Sales accounted for by the profit. For example, if the Sales Amount is \$1000 and the Profit is \$100 then your pie would show a slice for profit that is 1/10 of the sales. I'd think that would make sense and the calculations in Tableau would be relatively simple to do.

• ###### 5. Re: To find percentage of different measures in pie chart using filled map charts

Hi, just following up on this one. Let us know if we can be of any further assistance.