How-To: Create a Column Selector

A column selector is a drop-down list from which a user can dynamically change the columns that display in results. By changing the measure columns, you can alter the content of the analysis you have created. To create a column selector on an anaysis, first select the columns you would like to use from the Subject Areas.

Navigate to the Results tab and under the Views section, click "Column Selector." Then, click this icon:  . A new section will appear for the column selector.

You can drag this newly created section above your table if desired. Next, click the edit button ( ) in the Column Selector section and it will take you to a page where you can check off which columns to include selectors in. Check off the column that you would like to be the measure column.

 

Once checked off, you can then add more columns by double clicking them in the Subject Areas. In the image below, you will see that I have added Department, Agency, and College/Unit to the column selector.

You can also create a label for your column selector to give it a unique name.

At the top right of the page, select "Done" and save your work.

You will now be able to filter data amounts based on the column you select.