Customer Aging report


I got stucked in Customer aging report. Below is my Query.

In customer master I have Accountnum and new field Status

Now I have 3 customer

AccountNum 1101,Status–Yes

AccountNum 1102,Status–Yes

AccountNum 1103,Status–No.

In report, customer wise balance is coming but I want balance based on HQ and sum up the balance for that customer.

Like, Customer 1–Bal=1000, Status-Yes

Customer 2- Bal=2000,Status-Yes

I want balance 3000 for same Status type.

If anyone have idea then let me know.