BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
thiagoglima
Obsidian | Level 7

Hi,

 

I'm trying to rank the top 10 difference between my gross price and net price. I need to show just the top 15 difference in my table, but I'm not getting how to do this.

 

I've tried using the Rank option on the Report Build. I created a rank using the 'dif' column and setting the higher (and tried with the lower too) counting = 15, but nothing happens: 

 

top 15 image 2.JPG

 

 

I don't know what I missing here, anyone can help me, please?

 

Sorry for the English.

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Super FREQ

Hello,

 

I think your issue is caused by using ranks and hierarchies together in a crosstab. In later versions of VA, crosstabs will not attempt to show multiple levels of a hierarchy when there is a rank on one of the categories in the hierarchy.

 

For the report object that you show in your image, I think you might have more success creating it as a list table and then applying the ranking to that.

 

Let us know if that helps!

 

Thanks,

Sam

View solution in original post

2 REPLIES 2
Sam_SAS
SAS Super FREQ

Hello,

 

I think your issue is caused by using ranks and hierarchies together in a crosstab. In later versions of VA, crosstabs will not attempt to show multiple levels of a hierarchy when there is a rank on one of the categories in the hierarchy.

 

For the report object that you show in your image, I think you might have more success creating it as a list table and then applying the ranking to that.

 

Let us know if that helps!

 

Thanks,

Sam

thiagoglima
Obsidian | Level 7
Thank you Sam for your answer. I think to use a list table will be my unique viable option.

Best Regards,

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1818 views
  • 1 like
  • 2 in conversation