Dynamic Crosstab Columns

[Ramakanthkrovi]

Hi Team,

I tried searching but was unsuccessful so posting as an idea, please let me know if it is already implemented.

Using a button bar or a list control to be able to pick columns(measures) that should be displayed in the same crosstab.

For example, if I select "Revenue" all columns starting with REV_ (or containing rev in column name) only to be displayed in the crosstab/list table.

It is similar to what I want to show using a data step- 

data a;

set x;

keep rev_:;

run;

Something around this would be useful to save columns displaying null/missing when using controls.

[AnnaBrown]

Thanks for the idea! We'll factor in this feedback as we plan future releases.

[AnnaBrown]

In SAS Visual Analytics 8.4, authorized viewers can change data items assigned to table columns. You can also do this in a pie, bar chart, etc. See related doc for report authors - SAS Visual Analytics 8.5, Working with Report Content:

Use the Viewer Customization options to control the customizations that a user who is viewing the report can make. Use the slider to select the following levels of permissions:

1. Simple edits enables report viewers to make changes that do not change the report designer’s original intent for the report content. For example, report viewers can change how the data is sorted or change legends and value labels.
2. Comprehensive edits enables report viewers to make changes that might alter the original intent of the report. For example, the report viewers can change object types. (This is the default level.)
3. Data edits enables report viewers to change the data for the objects in the report. For example, they can change data assignments, filters, and ranks.

And doc for report viewers: SAS Visual Analytics 8.5, Working with Data Assignments.