KNOWLEDGE BASE

Row Grand Totals do not Display When Exporting Crosstab to Excel


Published: 06 Mar 2018
Last Modified Date: 03 Sep 2019

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 by temporarily removing 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.
Did this article resolve the issue?