Thank you for your quick reply, the solution you proposed was worked well but now the requirement got slightly changed,
Please see below,
Three more columns got added to the cross tab in between Sales and Profit,
The requirement is I want to display Sales on Starting date (01-01-2010 i.e., 0.19K) and Profit Ending Date ( 31-12-2013 i.e., 2.29k) Same like previous one but the values of Shipping cost, Unit Price and Discount has to display for whole selecting period(Date range filter) i.e, 01-01-2010 to 31-12-2013.
The output should be like below for the date rage filter 01-01-2010 31-12-2013
( Sales - 0.19K
Shipping cost- 120.6k
Unit Price - 832.4k
Discount - 468
Profit - 2.29k
Please help me on this.
Happy to hear that
If this solved your question, would you please take a moment to mark my answer as correct?
If you don't know how to mark, please refer to this post
Tableau Forum Guidelines => Mark responses as helpful or correct answers