Sub-total Commission by Broker Name and Transaction Code

[1cutedimple]

Hello,
I have data that contains Broker Name, Transaction Type and Commission. There are 3 Transaction types: NP, WD and RI. WD is actually 2 types combined as one: FR and PR.

I have a formula that gives me count of each transaction type by Broker Name. But what I need now is a total of Commission by Transaction Type then by Broker Name. The Commission field is defined as string.

The report should look like this:
Broker Name:
Count of NP
Total Commission of NP

Count of WD
Total Commission of WD

Count of RI
Total Commission of RI

Grand Totals

How can I do this?

 

[budbeth]

Add another group (Group #2) for the Transaction Type.
Then create a formula to count & add to the group footer.

Beth L.

 

[1cutedimple]

Hello,
How can I separate the totals for each Trsnsaction Type?

Thanks.

 

[lbass]

If you insert a group on transaction type, you can then right click on any recurring field and insert a summary (count). Then also right click on the amount field and insert a summary (sum) at the group level. You can position these however you like in the group footer or group header.

-LB