Dates.

[#1]

Hi Friends

I have a chart that contain 3 columns..

1.Fisicalweek--Calender Table(dimension)

2.OrderDate--Header Fact Table

3.Shippeddate-Header Fact Table

In this There is a Association between Calender and Header Fact Table.

The main thing is I want to find the Total no of "OrderDates" Per week and Total no "ShippedDates" Per week .. These two are Date Fields

I am getting Total No Of "OrderDates" Per week By using Count(OrderDate) . if i apply the same thing for delivery date

But i am not getting Total no "ShippedDates" Perweek.

So Could you please help me how to find the Total no "ShippedDates" Per week.

I was trying this using set analysis but i am not getting the exact result.

Thanks&Regards

[MK_QSL]

If you could give us your sample file would be helpful to redirect you in proper direction.