How to Top N by Sum in Bar Chart

[Derick]

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.

[koyelghosh]

Please post a little more detail.

[Derick]

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.

[PeterClemmensen]

Modify the code a bit in An easy way to make a "Top 10" table and bar chart in SAS

[Derick]

I just use SAS VA, didn't use any coding.   How I use the coding in SAS VA?

[PetriRoine · Accepted solution]

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

[PeterClemmensen]

Ah ok, Didn't see that. I have no idea about VA 🙂