Setting Up Aggregation and Roll Up in Report Author Query

[gosoccer]

Hi folks,
I have the following scenario:

CAR ID                REGION CAR COLOR    CAR TYPE     PURCHASE COST    REPAIR COST
MAZ-1111                 MD      G                  A                  2000                 2000
------Same kind of record shown above
------
------
MAZ-1121                  VA      B                  B                  3000                 4000
-------Same kind of record shown above
-------
-------


------- means additional rows.

Now in the Crosstab, I have to show:

                                         
                     CAR TYPE  A          CAT TYPE B
REGION A               5                        10
REGION B               3                        12
So I need to use the right Rollup and Aggregation to come up with this.   

I have my query to include all the five Data Items and using the Aggregation=Count and Roll Up Total.
I also turned off the Automatic Summary of the Query (Changed to "N")

My counts are not correct and the #'s on the Query is not showing correctly.

Please help if you can.

Thx so much. :) :)