Two sets on data on one report

[DevRev]

Hi,
I have a table which is basically deposit information something like this

Category Transaction
Category 1 $100
Category 1 $50
Category 2 $100
Category 1 -$100
Gategory 1 -$75
Category 2 -$100

I need a report which will sum the totals for each Category and group them by category. Then sum the debit totals for each category and group them. Like this:

Deposits
Category 1 $150
Category 2 $100
Total $250
========================
Debits

Category 1 -$175
Category 2 -$100
Total -$275

 

[pbaldy]

In the query the report is based on, add a calculated field:

TransType: IIf(Transaction > 0, "Deposits", "Debits")

Then in your report, group by that field and then category.

 

[thatlem]

Create two separate groups and put a sum for the corresponding field within the specific group. Then create a sum field and put in the report footer.

 

[DevRev]

Paul,
Thanks a lot. That's exactly what I needed.

Tenney