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.
Available selectors:
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:
