I have this case:

Table Fact:
DocumentNo
CustomerNo
Amount

Dimension:
Periods: Year, Quarter, Month

I need a Member that provied a Distinct Count of Customer that have
Invoiced.
For example:

Year Quarter Month Sales Amount CustNo
2004 1 1 1200 35
2 2000 20

etc..

How can I do by MDX?

Thank you
Dario Concilio

1. define a measure x = Dist Count of CustomerNo
2. during query, simply do a filter, based on Sales Amount>0 (you need to
write MDX)

Hope it can solve your problem


"Dario Concilio" <dario.concilio (AT) dakyn (DOT) it> дÈëÏûÏ¢
news:e52oeSB6EHA.4028 (AT) TK2MSFTNGP15 (DOT) phx.gbl...