Changing Sum in Crosstab to Count

[EMVIC]

Hi, I'm new to BO and would appreciate any assistance to help me get through this first hurdle. I'm using BO 5.1 and Db is Access. Below is a sample data I used.
id Type Region
233 Lamp West
334 Plug North
5 Bulb South
5 Frame West
55 Lamp East
888 Bulb West
When I tried to insert a crosstab in BO, I got the result below:

Sum of id Region
Type East North South West Grand Total
Bulb 5 888 893
Chandelier 334 334
Frame 5 5
Lamp 55 233 288
Grand Total 55 334 5 1126 1520

How can I change it to give me Count instead of sum. Below is the Output I expect:

Count of _id Region
Type East North South West Grand Total
Bulb 1 1 2
Chandelier 1 1
Frame 1 1
Lamp 1 1 2
Grand Total 1 1 1 3 6

 

[lbass]

When you enter the summary in the crosstab there is an option to change the summary below the box where you entered the summary. Click on that and choose count as the summary.

-LB