KNOWLEDGE BASE

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: 22 Jun 2021

Issue

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

Environment

  • Tableau Desktop

Resolution

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.

Cause

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?