Problem Note 66126: The label for the "Total" column might be missing when you export cross tables in SAS® Visual Analytics
 |  |  |  |  |
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:
- Create a new report that contains a cross table with a data item for a Columns role and another one for a Rows role.
- Select the Totals (Rows and Columns) option in the Options pane to display the total for rows.
- 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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS Viya) | Cloud Foundry | 8.5 | 8.5.2 | Viya | Viya |
| Linux for x64 | 8.5 | 8.5.2 | Viya | Viya | ||
| Microsoft® Windows® for x64 | 8.5 | 8.5.2 | Viya | Viya | ||
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
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya 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
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-12-22 10:58:04 |
| Date Created: | 2020-06-12 05:59:49 |