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:
![crosstab](addl/fusion_64855_1_8.jpg)
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.
![wrong sort](addl/fusion_64855_3_64855_wrong_sort.jpg)
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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-11-08 09:15:03 |
Date Created: | 2019-10-03 09:12:41 |