1 of 1 people found this helpful
I have modified your workbook to get the answer you are looking for. I don't know if this answers your question. Try it and let me know.
Tableau Architect at Cisco Systems
I made a fix that isn't very practical, but it does get the job done. Basically I just made a dashboard and put floating boxes over the headers that change based on the reference date filter.
Thanks much Noel. It solves my problem in this particular case. But is there another way to do it? I mean if we have 2 dates your solution is perfect, but lets assume we have 1,500? That will make it it a bit more complicated. Still thanks much for help!
Ya if you change field used on sheet "date1" to the field date1_text and the field used on sheet "date2" to date2_text it should be able to handle however many dates you want.