Allowing Users to Change Columns in Reports

A column selector is a set of drop-down lists that contain pre-selected columns. Users
can dynamically select columns and change the data that is displayed in the views of
the analysis.
One drop-down list can be attached to each column in the analysis, and multiple columns
can be attached to each drop-down list. You can create drop-down lists for
attribute columns and measure columns. Updates that you make in the column selector
view affect all the data views in the analysis.

How to …

Add a Column Selector View

1. Create or modify the report with which you want to work.

2. Click the button and choose Other Views > Column Selector using the dropdown,
cascading menu.

3. Click the button for the column selector view. The workspace shows the
options and settings for the view.

4. Select the Include Selector option for each column that you want a column selector
to appear.

5. Type a label for each selector and select a position for the label.
note: If you do not type a label, users viewing the results will not see a label on the
selector.

6. Using the Subject Area pane, double-click the columns you want in the selector.
To remove a specific choice from a column selector, click the button.
To remove all choices, click the Clear Choices link.

7. Click the button (Column Properties) to specify the column properties. The Column
Properties dialog appears.
Specify the properties, as required.

8. Click the  button (Edit Formula) to edit the column formula. The Edit Column
Formula dialog appears.

9. Click the button.

10. Click the button to save the report with the column selector view.