topic Re: Ranking top 15 in Visual Analytics in SAS Visual Analytics

Ranking top 15 in Visual Analytics

thiagoglima — Wed, 31 Oct 2018 15:25:46 GMT

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:

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

Sorry for the English.

Re: Ranking top 15 in Visual Analytics

Sam_SAS — Mon, 12 Nov 2018 14:38:13 GMT

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

Re: Ranking top 15 in Visual Analytics

thiagoglima — Tue, 13 Nov 2018 19:32:21 GMT

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

Best Regards,