I have a barchart where Category set to Customer, while Measure set to Amount. I need to show Top 10 record in barchart. How I can do that? Please help.
Hello @Derick
Have your tried to use Rank? You can use the Ranks to subset the data in your visualizations. A rank selects either the top (greatest) or the bottom (least) aggregated value for a category.
Best regards,
Petri
Please post a little more detail.
I have attached my current bar chart. Now it show all customer record in the bar chart, I need show only Top 10 amount in barchart
instead of all customer record.
Modify the code a bit in An easy way to make a "Top 10" table and bar chart in SAS
I just use SAS VA, didn't use any coding. How I use the coding in SAS VA?
Hello @Derick
Have your tried to use Rank? You can use the Ranks to subset the data in your visualizations. A rank selects either the top (greatest) or the bottom (least) aggregated value for a category.
Best regards,
Petri
Ah ok, Didn't see that. I have no idea about VA 🙂
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.
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.