KNOWLEDGE BASE

Crosstab Export Differs Between Tableau Server and Desktop


Published: 01 May 2014
Last Modified Date: 20 Dec 2016

Issue

When you export a view as a crosstab from Tableau Server, the resulting CSV file might differ from the CSV you get using the Crosstab to Excel export feature in Tableau Desktop.

Environment

Tableau Server 

Resolution

Use one of the following workarounds.

Option 1: Export from Tableau Desktop.
  1. Download the workbook from Tableau Server.
  2. Open the downloaded workbook in Tableau Desktop.
  3. Select Worksheet Export Crosstab to Excel.

Option 2: Format the fields that are incorrectly summed to display with decimals.
  1. Open the workbook in Tableau Desktop.
  2. Right-click the field you want to edit in the Measures pane and select Default Properties Number Format.
  3. Choose Number (Custom).
  4. Under Decimal Places, select at least 2, then click OK.

Cause

The export from Tableau Server exports the underlying data, while the export from Tableau Desktop exports the data in the view.
Did this article resolve the issue?