Multiple Filters on a Single Field in SAS VA 7.5

[ldenney]

I need a report filter set up for 2 pages on my SAS VA Report and I would like to use 1 report filter for both pages. The field I would like to filter on (client) contains multiple client names as well as benchmarks.

Page 1 contains a crosstab for a single client. The second page has a line graph with 4 individual benchmark lines (these rarely change) and I would like to select an individual client to view on the graph with the benchmarks. I have no problem with page 1 with selecting client name and the crosstab displaying the correct information.. The second page with the graph, when I filter on the client name, I lose the 4 benchmarks on the graphs. There are 450 clients so using multiple selects from a list seems unwieldy.

Any help is appreciated!

[FredrikE]

Hi!

One way you might solve this in is to create a calculated measure that get the value you want to show when then client name is the same as the selected one. You need a parameter that is assigned to the selection box. The formula could look something like this:

IF [parameter] = client_name then RETURN value

ELSE return .

THen use this calculated measure in your benchmark graph.

//Fredrik

[ldenney]

Thank you! I will give this a try and let you know how it goes