Problem Note 64855: Custom sort order is incorrectly applied in SAS® Visual Analytics crosstabs when the AggregateTable operator is used in a calculated item
 |  |  |  |  |
A custom sort order might not be applied correctly in a crosstab. Specifically, this problem can occur when the crosstab includes a calculated item that uses the AggregateTable operator. For example, the following display shows a measure named Calculated Item 1 that uses the AggregateTable operator:
In addition to the calculated item, a custom sort is defined on Month in order to display the months in chronological order.
When Calculated Item 1 is placed in the crosstab, the custom sort order is not applied correctly. The months are displayed in alphabetical order instead of chronological order as defined by the custom sort.
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.3.1 | 8.5 | Viya | Viya |
| Linux for x64 | 8.3.1 | 8.5 | Viya | Viya | ||
| Microsoft® Windows® for x64 | 8.3.1 | 8.5 | Viya | Viya | ||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesWinAn update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-11-08 09:15:03 |
| Date Created: | 2019-10-03 09:12:41 |