Selectors are probably the most powerful components of all. Their overall functionality lets you create models with multiple selections. When you combine a selector with another component, for example a chart, the result is a powerful, dynamic model that is both elegant and easy to create.
Table: You might be surprised with the Table component. It is a "What you see is what you get" representation of a group of cells from your Excel file. In addition to this, each row will allow multiple selections. For example, you can use the table to display a Balance Sheet for two years such that when you click on each row, the table displays an additional chart that shows the historic balance for each account.
Play Selector: The play selector will sequentially insert one row or column from a defined range. You can then use that row to create a chart that will change each time the play selector inserts a row or column. For example, use the play selector in models that show Sales for a large number of Sales Representatives. Instead of having to click several times to display a chart for each Sales Representative, you can create a model that will automatically run the charts with just one click.
Radio Button, Menu, Combo Box & List Box: These are some of the industry favorites. They permit one selection at a time from a group of selectable items. They are easy-to-use and easy-to-understand.
Toggle Button & Check Box: A set of selectors that have two positions: ON & OFF. With each position, the content displayed may vary depending on your needs.
Filter: The Filter component takes a range of data that shares a common number of items and "filters" the content so that there are no duplicated records.
One of the most important characteristics of Crystal Xcelsius™ is how easy it is to create a model using selectors. Typically, to use selectors you would need to create or use a program that is not easy to understand. At a minimum, you would need some programming skills. With Crystal Xcelsius™, you will be surprised at two things: How easy it is to use, and how powerful your models will be.
In this section, we will explain the main functionality of the Crystal Xcelsius™ selectors. For your convenience, we have created a series of self-running animations describing each selector's functionality. These animations are available on the Property Window of each selector. Just bring up the property window for the component and then click on the icon. The animation will run automatically.
Selector behaviors included in Crystal Xcelsius™:
Recommended Use: Use the Position function when working with Excel Lookup functions or when using Excel What-if formulas.
Recommended Use: Use the label function when working with Excel Lookup functions or when using Excel What-if formulas.
Recommended Use: Use the Value function to display a single cell that contains one value for each selector item. You can then use other components, for example a Value component, to display the selected value. The value will change with each selection.
Recommended Use: Use the row function in models that contain data categorized in rows, in models where you use dynamic charts, or in models where the selector contains more than one cell of data.
Recommended Use: Use the column function in models that contain data categorized in columns, in models where you use dynamic charts, or in models where the selector contains more than one cell of data.
Recommended Use: Use the status list to display different charts or other components that are visible or invisible according to the selector selection.
The following table describes the functions or behavior that apply to each selector: