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 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.