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. :) :)