Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add customer and product as dimensions to your straight table and =count(product) as measure