Subtracting dates

Subtracting dates

Post by Melis » Sat, 06 Apr 2002 02:31:55



I am new to Analysis Services.  I can create a cube showing sales per
date by region etc.  But I am having problem getting the Average time
between purchases.

Here is my problem:

Customer Table
--------------
CustID
------
1
2
3
4
5

CustomerSales Table
-------------------
CustID    SaleDate
------    --------
1         1/1/2001
1         2/1/2002
1         3/2/2002

Can you help me?  I am not sure how to setup a measure for that in
Analysis Manager.

Email me personally.

Thanks!

Melissa Alamo