Hi All, I hope this is not a usual question with DISTINCT COUNT. Here is the
case:

AS Version: 8.00.2039

I have my standard SALES cube, with CUSTOMER, PRODUCT, TIME, etc. dimensions.
The cube has DISTINCT COUNT of PRODUCTS - that's fine. On the lowest level
this is fine, however I need to roll them up not as AVERAGE not DISTINCT
COUNT.

E.g.
Customer1 (Unit1), has products: A, B, C, D, E (distinct count = 5)
Customer2 (Unit1), has products, A, B, C, D (distinct count = 4)

My AVG_PRODUCT_COUNT for Unit1 needs to be 4.5. Standard implementation of
distinct count gives me 5 obviously.
It should work the same way for all dimensions.


Many thanks for hints,
Robert