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.