Field as percentage of another field

[gerhardl]

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.

[gerhardl]

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

[gerhardl]

This is what I would like:

[spividori · Accepted solution]

Hi.

I hope this is what you want!

Regards.