calculate distinct apearences of a dimension in a dimension

[aheavy95]

Hi all

I want to calculate how many distinct products are in one order (preferably an app calculation, not in script).

SalesOrderID- an entire order

SalesOrderDetailID  - "mini order"of one productinside the order with info about the qty etc

How can I find out how many different products are in one SalesOrderID?

thanks 

[vinieme12]

count(distinct Products)

[aheavy95]

I need a calculation that is per salesorderID 

[vinieme12]

What is your chart Dimension?

What exactly are you trying to create?