1 of 1 people found this helpful
The easiest way is to create a separate excel file containing your all months and then Join it with your data. Now, Bring the Excel sheet Months on Columns in Tableau to give you Different Months. Then Use this Calc and bring it Into Text Label.
If it Helps, Pl Mark it Helpful and CORRECT to close Thread
Thanks for the reply and help
How do i join the dates excel sheet to this??
In data view create a join calculation on your excl dates file to make it similar to your dates in your dataset make it left join and one more thing i see that you have 2 dates so pivot your start and end dates as one date column and then join with excel data. I am away from computer if u are not able to do i will do when i can do
Hi thank you once again deepak,
I am a bit confused how to do this, when you are on your computer can you do this on my example tableau sheet i attached please?
thank you so much
I will look at that.
what is the best approach I can take to do this?
How should i structure the data ti take the first approach you mentioned?
I am really struggling to do this , can you provide any more tips for this?
IS it possible i can email you regarding this task? i am having great difficulty fixing this.