When you export cross tables in SAS Visual Analytics, the label for the Total column might be missing in your Microsoft Excel output.

For example, you might encounter this issue if you complete steps similar to the following:

1. Create a new report that contains a cross table with a data item for a Columns role and another one for a Rows role.
2. Select the Totals (Rows and Columns) option in the Options pane to display the total for rows.
3. Export the cross table. The label for the Total column might be missing in Microsoft Excel.

Note that the problem occurs only when you select the Totals (Rows and Columns) option and you do not select the Subtotals (Rows and Columns) option.

As a workaround, also select the Subtotals (Rows and Columns) option.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at