count and group by

[stavc]

hi all,

i need to do a count and group by.

I have a straight table in which i have one column of costumers and the other column is products the costumer ordered.

i need to know how many products ordered made each costumer.

for example:

costumer        product

1                            table

1                            table

1                             chair

1                             computer

in this case i need to see that costumer 1 ordered 2 tables, 1 chair and 1 computer.

thank you all

[Gysbert_Wassenaar]

Add customer and product as dimensions to your straight table and =count(product) as  measure