The Row Order of Exported Crosstab Is Different from the Worksheet When Field Is Added in [Mark] Card

Published: 22 Jun 2021
Last Modified Date: 08 Jul 2022


When adding a table calculation filed in the view and then add another field in Mark Card, Then the downloaded CSV file looks different from Tableau View.
User-added image

For example, when using the RANK field, The exported crosstab are as follows:
When no field is added in the [Color] mark, it works well.
User-added image

When a field is added in [Color], the row order are different.
User-added image


  • Tableau Desktop


1. instead of exporting CSV, please use [Copy] > [Crosstab]. 
User-added image

2. Please manually set the order of the rows using the [Sort] function.
User-added image

Please check the attached workbook, [Workaround] worksheet.


This issue is currently under investigation. 

Additional Information

If a table calculation filed is added in the following cards, the exported CSV row order will be different from the view in Tableau.
User-added image
Did this article resolve the issue?