Crosstab with counts for each cell?

Sapphie

Can anyone point me in the direction of an example that shows a crosstab where each cell is actually a count?

For example, say I have a table with an entry for each sale of widgets with columns:

Sale_Location, Sale_Person, Sale_Made, Sale_Ref

I want a crosstab/table that has Sale_Location down the left hand side and Sale_Person across the top and each cell showing the total number of sales made for that location by that person.

At the moment I am doing the count(*) and grouping within the SQL and then putting the count(*) value in the cells.

Is there a way to do this within the report? I am probably missing something very simple!

Thanks

Lee

thuston

You can change the Aggregation of your measures in the Cube designer. It is SUM by default, but you can do many others (including COUNT).