Hi,
I've got a report filter consisting of 1 category. However I would like to display 2 categories in the filter. So when you click on the filter,
you can also see the sub category in the filter.
I enclosed a (non SAS VA) screenshot to point out what I mean. I've seen somebody do this in the past but I don't know how he did it.
Thanks !!
RGDS
William
You can create controls that cascade, so that when you select a value in one control it filters a second control with only applicable values. Is that what you are looking for? You would use actions to do this.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Hi Madelyn,
Thanks for your answer. I'd like it to appear as a pop op menu just like at the top of a web site.
I've found a solution with list tables in a prompt container which dynamically interact because of the parameters filtered.
However it's not really what I want.
I'm not sure if I understand your solution well. Do I get the desired result with this. Do you have an instruction on how to do this ?
Thanks !
Rgds
B
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.