Crystal Report Group by Formula

Hi,

I am a novice and any help would be much appreciated.

The database I am using is as below:

A/C No. Name Payments

1 Brown 10.00
1 Brown 25.00
1 Brown 40.00
2 Jones 100.00
2 Jones 150.00
2 Jones 175.00
2 Jones 56.00
3 Smith 65.00

I have grouped the report by account number. I have then created a formula that categorises the customer based on their payments. I then wish to group customers by these categories but Crystal will not allow me to do so.

The best I can do at the moment is export the initial report to Excel and then create a new report in Crystal based on this.

Can anyone point me in the right direction?

Thanks

Andyyou can group by using formula
can u write the formula, so that i can check it.