Chart Total based on 1 field only

[crogers111]

CRXI
SQL

I have 3 currency fields I'm subtotaling with example data:

Billed = 5000
Reduction = 2000
Allowed = 3000


I'd like to have a chart (pie chart is preferred) that shows 100% as 5000 (Billed), 40% as 2000, & 60% as Allowed.

Currently the chart is adding all 3 values (for a total of 10,000) and showing slices and percentages based on this total.

Is it possible to have a chart's total be based on 1 fields (Billed) total and have the other slices be proportional as well ?

 

[crogers111]

I found if I changed the Chart Type to: Numeric Axis Bar Chart, I get close to what I need. I don't get the percentages functionality but the 'stacked bar' appearance where the 'Billed' Amount is the top value is what I need. I can manually add % values