Is this possible?

[Simply Me]

i have the following records in my table
ClientID Budget Purchases Selling
SOCO-Apopong 960.00 55.50 63.82
SOCO-Calumpang 960.00 56.25 64.68
Doctor's Hospital 3000.00 72.75 83.66
SOCO-Main 5000.00 147.75 169.90
Office 500.00 50.00 57.50


Is it possible to create a report using CR9 with this kind of output:
ClientID Budget Purchases Selling
Doctor's Hospital 3000.00 72.75 83.66
SOCO-Apopong 960.00 55.50 63.82
SOCO-Calumpang 960.00 56.25 64.68
SOCO-Main 5000.00 147.75 169.90
Total 9920.00 332.25 382.06
Office 500.00 50.00 57.50

I want to exclude from the total the records for office. Is it possible?

[brucevde]

Create RunningTotal fields. In the Evaluate section create a formula that excludes the record when the client id = office.

[Simply Me]

there is no specific ClientID yet for the office... so what if the user uses other ClientID?

[Simply Me]

Where do i find the evaluate section? Im a bit new to CR9. can you give any steps i should do please?

Note that I still need to display the records for the office below the total.