sql plus question

I have a query that will product a report broken down this way:

'store name' 'store number' 'store total' 'transaction type' '# transactions'

xyz                    500000            $5,555.00          1
3
                                                    $200.00           3

my dilemma is this: there are 6 possible transaction type. I can break the report on transaction type so that any given store with more then 1 type of transaction has them listed on a new line. (as shown above). I want to either, 1) at the end of the report to show report total count for type 1, 2, 3, 4, 5, & 6. or 2) modify
the output so that each transaction type has it's own column. (that way excel can do a sum on the column)

my choice is the 1 option. report just looks cleaner. But, I don't know how to do that. HELP please....

Thanks in Advance. Received on Thu Nov 18 1999 - 14:21:19 CST