KNOWLEDGE BASE

When Exporting to Crosstab to Excel, Row Grand Totals do not Display


Published: 06 Mar 2018
Last Modified Date: 07 Mar 2018

Issue

When exporting to an Excel crosstab with a dimension on a Marks card, the Grand Totals are blank.

Environment

  • Tableau Desktop
  • Excel

Resolution

Re-enable the exporting of Grand Totals to Excel the following way:

Temporarily remove all Dimensions from the Marks cards (Color, Size, Text, Detail, or Tooltip).

Cause

Dimensions on Marks cards are moved to the rows or columns shelf for inclusion in the export. This can create a situation where ATTR([Dimension]) is on the rows or columns shelf, which disallows the use of Grand Totals to prevent problematic situations. Thus even if the Grand Totals would be valid, the criteria for Grand Totals within Tableau Desktop are not met and so they are not computed during export.

A solution is being investigated under ID 376353.
Did this article resolve the issue?