number of occurences of a member

[devnoronha]

Hi,
What is the function which returns the count of the number of occurences of a member ? If the follwoing is the table :

1 John 200
2 John 300
3 Pete 100
4 Ralph 100
5 Pete 100
6 Pete 100

I've created the cube which shows me the 3 sales guys names and the Total Sales by each :
John 500
Pete 300
Ralph 100

What I want is to also display the number of sales . The cube should display as follows :
Name Tot Sales Number of Units
----------------------------------------------------------
John 500 2
Pete 300 3
Ralph 100 1

How do i crete the calculated member for 'Number of Units' ???

 

[johnherman]

You did not state what application technology you are using, but the COUNT function is available for Calculated Members in Microsoft Analysis Services.