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...
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.
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?
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.
Hi, just following up on this one. Let us know if we can be of any further assistance.