Error "The dataset contains multiple values for a single cell. Only the first value will be displayed [...]" After Attempting to use the Export Crosstab to Excel Option

Issue

When exporting a view using the otion "Crosstab to Excel", the following error might occur and the export in Excel will not contain all data:

"Warning: "The dataset contains multiple values for a single cell. Only the first value will be displayed. Please consult the help index entry on "overlapping text" for clarification."

Environment

Tableau Desktop

Resolution

The following steps can be reproduced in the attached sample workbook Only the first value.twbx.

Create calculation field using the INDEX() formula.
Convert this newly created calculated field to Discrete from the Measures pane.
Drag the calculated field to Rows, next to the dimension Category.
Right-click the calculated field from Rows and select Compute Using > Order Date
Then, export the worksheet as a crosstab to Excel