Ranking top 15 in Visual Analytics

[thiagoglima]

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.

[Sam_SAS · Accepted solution]

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]

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

Best Regards,