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

Published: 06 Mar 2018
Last Modified Date: 14 Oct 2018


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


  • Tableau Desktop
  • Excel


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).


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?