Pie Chart Calculations

[ksimmons]

I have a data source with the following data:
Col1 Col2 Col3 Col4 Col5
ABC 20 40 30 0
DEF 340 0 300 45
GHI 0 0 0 0
JKL 200 20 0 30

I want to be able to display a pie chart in my report that displays the following calculation for each Col1:

(Col2 + Col3 + Col4)/(Total of all Col2 + Total of all Col3 + Total of all Col4)

My Argument in the pie chart is Col1. I've tried to do a calculation for Value, but I keep getting errors that it doesn't recognize "Div".

[HighAley]

Hello.

Yes, it's possible. Please, look at the attached report template.

Report.mrt

(12.32 KiB) Downloaded 161 times

Thank you.

[ksimmons]

Could you please include the data source?

[ksimmons]

Actually, I was able to manipulate an XML file to be able to preview this. Unfortunately, when I change it from a bar chart to a pie chart, all I get is a blank box. Can you provide an example with a PIE chart? thank you.

[Alex K.]

Hello,

Please check the report in the attachment.

Thank you.