In Web Report Studio, 4.4 M3, I’m trying to display the top 20 objects in descending order. When I sort descending before ranking the sort works. When I rank the sort takes no effect.
Please try this:
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Can you post a screen shot that illustrates the issue? I see no issues sorting on a column that has been ranked.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
added screenshot
Please try this:
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Thanks, it looks like it was double sorted.
I think that the rank automatically applies a sort, so that any subsequent sorts are secondary sorts. Glad that removing all sorting worked!
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.