KNOWLEDGE BASE

Columns Out of Order in Exported Crosstab with Table Calculations in View


Published: 15 May 2013
Last Modified Date: 09 Jan 2017

Issue

The order of columns in a crosstab exported to Excel does not match the order of columns in the crosstab in Tableau Desktop.
There are calculated fields used in the view.
.

Environment

  • Tableau Desktop
  • Excel

Resolution

If possible, remove fields from Detail to retain the same column order as the view when exporting.
User-added image
 

Cause

Fields placed on Detail may impact the order of exported columns when calculated fields using table calculations are also used in the view.

 
Did this article resolve the issue?