Group By / Totals

[ksbrace]

I am trying to get some totals....I have assignedto, portfolio, paymentamount, status as columns.

What I have is:

select assignedto, portfolio, paymentamount "total payment money" from payments
 group by assignedto;

But that doesnt' give me the total amount of payment money for each portfolio for each collector.

I'm looking to see something like

collector1 portfolio1 4,500.00
collector1 portfolio2 3,000.00
collector2 portfolio1 2,000.00



any help would be great!

 

[ksbrace]

got it..
select assignedto, portfolio, sum(paymentamount)"total payment money" from payments
group by assignedto,portfolio;