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