Hi Team,
I have created a dashboard which has some column with 2 values: 'Amount' and 'Account name'.
When I am downloading it as a crosstab, 'acc name' doesn't include in downloaded excel file. itis saying as :
Dashboard:
Downloaded file(Crosstab):
: Missing act name in excel
Could you please suggest how can I bring acc name in crosstab with the same view I have created ??
Please find attached workbook.
Thank you in Advance!!
Regards,
Madhuri
Hi,
I can see that you're using a form of a multi-axis cross tab to get the desired layout. Then what's happening is Tableau's export to crosstab is picking up only the first axis in each "cell" created by the intersection of the different dimensions.
The workaround that I'd use for this would be to either do a self-union of the data or create a "scaffold" data source that would add an extra "Act Name or Amount" dimension. The self-union would give you a Table Name dimension that you could re-purpose for this use. Then you could use that and pills on Text instead of the multiple axis crosstab to get the desired layout.
Jonathan
