can we hide and show columns from list table based on filters

[ashishj816]

Hi All,

Based on filters can we hide and show columns which are present in cross tab.

[Kurt_Bremser]

Please provide the code that creates the cross tab, and tell us which columns you do not want, and the logic for filtering them out.

Providing usable source data (data step with datalines) will most probably speed up the process of finding a useful answer.

[ashishj816]

This will be on SAS VA Part in Dashboard

[Kurt_Bremser]

I moved your question to the Visual Analytics community. Since I do not use that product, I won't be of much help here.

[Sam_SAS]

Hello,

I don't think you can hide the entire column (including the column heading.)

What you can do is make all of the values missing, which will cause the table/crosstab to aggregate as if the column were not there.

Here is a nonsense example with SASHELP.CARS:

Let's say we want to ignore the Drivetrain column when "Asia" is selected in the button bar.

First we make a character parameter and assign it to the button bar.

Then we create a calculated item that uses that parameter:

IF ( 'Parameter 1'p NotIn ('Asia') )
RETURN 'DriveTrain'n
ELSE ''

Now when we select "Asia" in the button bar, we get this:

If you want the button bar to ONLY set the parameter and not also filter the data, be sure to place the button bar in the body of the report page and not in the prompt area.  That would give this result, which might be closer to what you wanted:

It's not exactly what you are looking for, but I hope this might help.

Thanks,
Sam