Need help calculating a metric

[evercognos]

I have a cube with this structure:

Time_Dim
Product_Dim
... (other irrelevant dimensions)
Sales_Fact

Now, the data is like this:


Month Day Customer Credit Buys Normal Buys Nº Credit Trans
01 2009-01-01 c_1 100 200 2
01 2009-01-02 c_1 200 300 1
01 2009-01-03 c_2 0 230 0
01 2009-01-01 c_2 500 500 1
01 2009-01-02 c_2 100 200 2
01 2009-01-03 c_3 0 400 0

I need to create a report with to metrics:

1.- Sales Amount: Sum(Amount) for month, the easy one....
2.- Number of client how made credit buys: if the customer made a buy in the month then I count 1 customer.., so, how many customers made a credit buy form month?

So the report should look like this:


Month
01 02 03 ...
Normal Buys 1.830
Credit Buys 900
Number of client 2


I'm trying to create a calculate metric but i dont know how...

 

[drlex]

If you have a dimension where the customer is an unique level, could you not use a category count on the customer level as a measure, the other measures being Normal Buys & Credit Buys?


soi la, soi carré