Hi Sai kiran ,
Can you post the sample workbook
since you are exporting to excel i suggest exposing parameter on to the row shelf which will be available in export
HI Sai kiran,
The first thing is what ever you have in the view it will be shown in cross tab or excel. when we are exporting from tableau cannot interpret anything the way you want.
1 of 1 people found this helpful
Thanks for thinking of me Tharashasank Davuluru
Hi Sai Kiran,
The label of the table is simply the name of the field. What you want are dynamic labels for your column names based on the parameter value? I think this more something for the ideas section. To help you on the sport:
Is the user exporting the cross-tab to excel or you as analyst? Is it too much to ask to manually change the headers in excel?
If you want to go really crazy and the amount of combinations of dimensions is still manageable you could instead of having the dynamic table in one view create a table on a worksheet for each of the combination of dimensions then link them together on a dashboard where the user would select the view in order to jump to the sheet he wants to export to excel. I am not saying that is an elegant solution but it could do the job. Trying to think outside the box.
Sorry I could not give you a more concrete answer here. Let me know if this helped anyways.
Sorry that i have misunderstood the requirement but still you can do it in
2 step process though from UX perspective its not the good solution
1. create calc field "[DIMENSION 1 PAR]'-'"
2. drop above calc field on row shelf whatever you select will atleast
display as a row value
attached is the sample one.
Giridhar Nandigam | Mobile : 1-(757)-814-9518 <email@example.com>
On Tue, Mar 8, 2016 at 4:48 AM, Tharashasank Davuluru <
Dynamic Cols.twbx 1.2 MB