Page 1 of 1

Pie Chart Calculations

Posted: Thu Jun 27, 2013 3:06 pm
by 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".

Re: Pie Chart Calculations

Posted: Mon Jul 01, 2013 8:30 am
by HighAley
Hello.

Yes, it's possible. Please, look at the attached report template.
Report.mrt
(12.32 KiB) Downloaded 160 times
Thank you.

Re: Pie Chart Calculations

Posted: Mon Jul 01, 2013 3:23 pm
by ksimmons
Could you please include the data source?

Re: Pie Chart Calculations

Posted: Mon Jul 01, 2013 5:12 pm
by 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.

Re: Pie Chart Calculations

Posted: Tue Jul 02, 2013 6:25 am
by Alex K.
Hello,

Please check the report in the attachment.

Thank you.