Is it possible to only display a number columns in a bar chart as interactions are selected?

[ghartge]

Greetings everyone,

I have a simple bar chart based on headcount in counties. There is one county that most of our data is from but there are 64 others. I can restrict the bars that are shown using a filter on headcount such as "Headcount > 300", but as selections are made in the report using dropboxes, all values for all counties can drop below the 300 value rendering a one bar chart or worse, blank. My question is does SAS VA allow for the filter to be dynamic or maybe something like "only show the top 10 values". (Please see the attached picture)

Thank you, everyone!

Gary

[FredrikE · Accepted solution]

It should work using rank on headcounts and only show the top 10, 15 or whatever you want. Click on the rankings tab to the right.

//Fredrik

[ghartge]

Thank you FredrikE! Sometimes it is the simplest things that escape us no doubt. Blessings