Hi,
I'm using the CR v 11 and I did a 3D bar chart that showing two series of data for each salesman , one is their outstanding orders and the other one is the closed orders.
Both bars are get the value from two running totals that I defined in the report by a distrinct count on salesman name.
For example for salesman_A , the bars are showing like
15 outstanding orders
70 closed orders
Now I want to show the percentage for the outstanding and closed orders. How can I do it?
Based on the example above.
The calculation is 15 / (15 +70) * 100 = 17.64%
Any suggetion? ideally can put that percentage on the report somewhere or as another data series on x aixes.
Thank you!