Hello,
I am looking for a common date calendar as picker which gives me counts from the fact tables for a product based on date.
All the fact tables are further connected with Productid. I want to establish something like when i select a month from common date picker it should give me count of products from respective tables below T1,T2&T3. How could i create a common calendar as a datepicker to drive the fact tables??
Example :
T1:
OrderDate
ProductID
T2:
ShippedDate
ProductID
T3:
ServiceDate
ProductID
Best Regards,
Vamsi
