
1. Re: To find percentage of different measures in pie chart using filled map charts
Ken Flerlage Sep 16, 2018 3:32 PM (in response to Dhiman Ban)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
DHRITIMAN BANERJEE Sep 16, 2018 9:36 PM (in response to Ken Flerlage)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
Chandran Sathish Sep 16, 2018 11:08 PM (in response to DHRITIMAN BANERJEE)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
Ken Flerlage Sep 17, 2018 5:10 AM (in response to Chandran Sathish)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
Ken Flerlage Oct 8, 2018 5:37 PM (in response to Dhiman Ban)Hi, just following up on this one. Let us know if we can be of any further assistance.