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.
I moved your question to the Visual Analytics community. Since I do not use that product, I won't be of much help here.
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.
The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.