I am entirely unsure why the need to download the list as a CSV makes using a floating object solution impossible. You could have another calculated field that returned 'Parameter 1' or 'Parameter 2' which are actually strings or just have your parameter you are using create these. You could then pass this information into the worksheet title dynamically. When using this on a dashboard you can make the worksheet title off centre so that it appears to be aligned above the correct fields.
I've created a sample workbook.
Dynamic Column Header.twbx 12.0 KB
Thank you so much for having a look at this. Floating objects: Please follow this link: | Tableau Public When you try to download the file as a CSV you will see that the header is "1 or 2" instead of the variable name.
Unfortunately, the same will happen with your solution. I have uploaded it to Tableau Public. When I click on generate CSV I get this:
So you can see that the column headers are misalligned.
Sorry for not being clearer about my requirements.
For what you are asking there is not a way to do this that I am aware of.
As the methods we've shown are intended to work on dashboards as visual
aids and not via crosstabs.
You could possibly use this blog:
and you could have multiple excel sheets that could be exported in the
background. The end user would not need to know how this is occuring and
only you would.
I was afraid that this would be the answer. Thanks anyways. And thanks by the way to the Interworks team, you guys post a lot of really useful stuff on Tableau.