Thanks TUSHAR for your reply.
Pivoting will duplicate my records , in this case repeating each order two times as we have order_date and pickup_date.
in my real data set, i have 6 dates to check on. this will duplicate each order 6 time , right? all other summations and counts of other columns will not be accurate at the moment, and the data set will be much bigger.
correct me please if i am not getting this right, and please suggest another solution if available.
the main thing is that making the date as 'relative' date is not possible, i tried using the method in this post earlier Re: Custom Dates AND Relative Dates as a Selection on a Single View
the same issue here, we have to make a custom list of relative dates and/or start,end dates to make this happen. but not being able to use Tableau relative filter functionality.
Thanks for your efforts Tushar.