Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to know how to create a pie chart showing one field as a percentage of another field.
I have a field called 'OTB' (which is available credit) and another field called 'Credit Limit' - I would like to know what percentage of the total credit limit for all customers (so Sum[credit limit]) is available to them.
So if the sum of all the customers' CL is 10 million, and the sum of all their Available OTB is 3 million, then I want a pie chart showing the 10 million, with 30% of it representing OTB.
Sandro,
Okay I've attached an example with 100 rows. I've made everyone's OTB R300 and their credit limits R1000.
So if I create a chart from that it should show a pie with two colors. OTB should be 30% of the chart.
Let me know if the example is okay.
Thanks
This is what I would like: