Hi I have scenario
Need to filter orderdate time and shipdate time
EX: How much sales happend between orderdate time and shipdatetime
I am using only one date dimension which i am connecting to order date,so when i filter it it is filtering orderdate time
not shipdate time
I guess i need to create two date dimensions one is for Orderdate and another one is shiipdate.
Please do the needful.
Regards
Thiru