Hi All,
I have three calculated fields as below. I would like to create a pie chart out of these three measures (each measure being a percentage of total).
Calculation [1 ]- if [Category] = "Furniture" and [City] = "Mount Pleasant" THEN [Sales] END
Calculation [2] - if [Category] = "Office Supplies" and ([City] = "San Francisco" or [City] = "Bossier City" ) and [Manufacturer] = "Other" then [Sales] end
Calculation [3] - sum([1]) + sum([2])
I understand that I need a dimension to create the pie chart , but I am unable to create one by pivoting the three calculated measures.
Any suggestions will be helpful. I have attached the workbook. Sheet I is a cross tab which shows the values that I used in calculating the measures.
Thank you!
Regards,
Rishi Saka
Hello @Rishi Saka ,
You can create a standard pie chart with measure names and measure values.
In order to show percentages, you will need a calculation like this for each measure.
SUM([Two])
/
(SUM([One])+SUM([Two])+[Three])
Hope this helps! See attached.
@Robert Breen
