Kindly provide me any insights. It would be a great help.
2 of 2 people found this helpful
If you had an example workbook it would be helpful...
Here is a guess, because there are 2 ways of exporting data -
I assume you used this option
Worksheet - Export - Crosstab to Excel
This should keep the format as you see in Tableau
Try this instead
Worksheet - Copy - Data
then open Excel and paste
This way fills the 'missing' spaces with data
Just a guess, hope it helps!
Thank you very much for your response.
I have column Branches in the "MARKS" , So the values are displayed in same row. In your example
Country in rows shelf and Segment is in Marks shelf. So i can get the below output in report.
Austria Consumer Corporate Home office
Belgium Consumer Corporate Home office
Denmark Consumer Corporate Home office
I am in need of exporting the results to excel in the similar format. But when i try to export it from report it is throwing the below error "The data set contains multiple values for a single cell. Only first value will be displayed. Please consult the help index entry for overlapping text for clarification"
But i am able to export it to cross tab from server after publishing it.But the exported data not in the same format. It is in the format you have in your excel sheet.
1 of 1 people found this helpful
Do you need the cities set up in that way?
The problem is Tableau works like a pivot table, in that on Export it needs 'single' values in the text card to be able to display them.
If you need to set them up to Export, I would arrange the pills as below
I know it obviously looks different, but at least it will export OK.
Its a trade off, either it looks like that and wont export or look different and export.
The other option is to create 2 sheets and (somehow) use one for display and the other for export.
OK, this is the last thing I got - sheet swapping.
In short you have 2 worksheets - 1 for display and 1 for export, then you have both
The display sheet
then the export
One is laid on top of the other (in a dashboard) so you never see both at the same time, only one or the other, and you can easily switch them using a parameter.
Working v9.2.1 attached.
This is an old (last resort) technique, there is a good discussion, with working example here > Excel Export: Two options to massively improve this functionality
Hope that helps!
aj sheet swapping.twbx 22.5 KB
We are able to export it as CSV. But it is not in the same report format. We need to export in the same format as in dashboard(Pivoted view).
I am facing similar issue what you have faced in the past.
Did you find an alternative to deal with the issue?
May I know the reason why the columns with multiple values cannot be exported to Excel?
The above solution doesn't suffice my requirement. I would need to export the data where columns have multiple values to excel.