Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
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 | ||