Introduction

Item Selector is available as a separate control in a Free Format Template. It represents a list of items that will be used as a Pick List in the report. Each item can be a combination of members from the dimensions associated with the list. Usually, the Account dimension is used. A common Item Selector can be applied to multiple controls within a Free Format Template report (e.g. to a Gauge and a Table), as well as a separate Item Selector can be used for every control in the report.

How to use Item Selector in a Free Format Template?

Let's consider an example, when we want to combine a Pie chart and an a Item Selector in a Free Format report. We want both the Pie Chart to "listen" to the same Item Selector - i.e. once an item is picked from the Item Selector, its values will be displayed on the Pie Chart.

CONTENT

To build such kind of a report, we need to take the following steps:

1. Create a Free Format Template, which will combine Item Selector and Pie Chart

2. Create a list of items to be included in the Item Selector

3. In Report Parameters for Pie Chart controls set "External Item Selector" parameter to "Item Selector"

4. In Report Parameters for Item Selector set "Item Selector" parameter to the required list of items

5. Optionally, you can set "Default Item Selector" and "Label Format" parameters of Item Selector to the required values (see section Parameters below).

As a result, we will get the report, where Pie Chart values are picked from the Item Selector list:

How to use other control as an Item Selector?

Now let's consider an example, when we do not want to use Item Selector as a separate control. Instead, we would like to combine a Table, a Pie and a Bridge controls in the Free Format Template. Then we will make the Pie "listen" to the Table rows - i.e. once we click on a particular row (which for example represents Account member), the values in the Pie and in the Bridge will be displayed according to this account.

To build such kind of a report, we need to take the following steps:

1.Create a Free Format Template, which will combine Table, Pie and Bridge controls (in our example we use account list for the table rows, Entities list for the pie chart )

2. In Report Parameters for the Pie set "Item Selector" parameter to "Table"

As a result, we will get the report, where the pie is changed according to the table rows:

Item Selector Parameters

Basic Control Parameters

Parameter	Description	Mandatory
1. Item Selector	A list of items that will be used as a Pick List in the selector	Yes
2. Default Selected Item	Indicates the Item from the List that will be selected / highlighted upon opening of the report. If none is selected, the 1st item will be selected.	No

Advanced Control Parameters

Parameter	Description	Mandatory
1. Label Format	Format, which should be applied to the items within the Item Selector	No