I am new to Crystal Reports, i need to chart ( Bar chart) based on a formula field.

 

I have one group - GrpA and a subtotal for that is a formula field which has conditions and calculations in that. Now i need to chart with GrpA Name on X-Axis and the subtotal field on the y-axis.

 

The subtotal field is based on 2 running total fields.

 

Here is the Report View :

 

GrpA : 1

Details: sss     dddd  date1 date2  (date1-date2)

---------------------------------------------------------------

Subtotal:                                           85 %

 

 

Calculation for 85% ( date1-date2 which are > 0) * 100 / (grpA Count)

 

I have used running totals for (date1-date2 whihc are > 0) and grpA count

 

But i am not able to chart based on the % i am calculating, Can someone plz help me.

 

Thanks in Advance

Shashi