05-06-2016 12:42 PM
In one of the report ( please see screen shot) i have a filter where values are more then 1000, but the VA is not displaying them, which is creating lots of issues in the Analysis,
is her a way to display all the values?
from the unlisted value my senior management want to select few and soe times all so what i need is following
1. is there a way to search the value ( as currently i am unable to search as VA throws an error if i want to search a value which is in unlisted bucket)
2. is there a way to search and select multiple values from the unlisted bucket as well from the main list?
3. can i display all
4. can i have another drop down filter where i can only display unlisted values from the previous filter?
many regards and thanks in advance to all who will respond
05-07-2016 06:06 AM
Is it possible to another column to your table with additional catagorization. For instance assign the station numbers to groups like (1000-1999, 2000-2999, 3000-3999) or prefilter to remove any stations that have smaller values? I realize this does not change the filters but it may allow you to better catagorize the data so the report drop-down could change it.
Possibly it will just give you some ideas about how to resovle the issue.
05-11-2016 12:18 PM
You can use the Custom Category option to organize the values.
Another option is to do it in SAS code. If the station numbers look like numbers - then change it to a numeric value and create your new category.