6.1.4  Displaying Aggregate Data in Selection List

To display summarized data next to the dimension values in a Selection List or Selection Tree, follow the steps below:

1. Create the Selection List (or Selection Tree) as desired.

2. Right-click the Selection List, and select 'Properties' from the context menu. This opens the 'Selection List Properties' dialog box.

 

3. From the 'Measure' menu, select the field that you wish to summarize.

4. From the 'Aggregate' menu, select the method of summarization. (See Crosstab Aggregation Methods for more information about the methods.)

5. (Optional) Enable the 'Text' option to display the aggregate values as plain text next to the corresponding dimension values.

6. (Optional) Enable the 'Bar' option to graphically display the aggregate values as proportional bars next to the corresponding dimension values.

7. Click 'OK' to close the dialog box. The summarized values are now displayed next to the Selection List dimension values.

You can also adjust the Viewsheet grid width to facilitate dis­play. See Resizing the Viewsheet Grid.

8. (Optional) Improve the appearance of the Selection List by making the following adjustments to the layout:

a. Adjust the column layout to provide the needed space by dragging the handle at the right side of column. See Changing the Column Layout in a Selection List.

 

b. Adjust the width of the aggregate text region by dragging the handle at the left side of the text.

 

c. Adjust the width of the aggregate bar region by dragging the handle at the left side of the bar.

 

You can also use the format controls on the Viewsheet toolbar to adjust the text and bar formatting.

9. (Optional) To format the aggregate text, right-click on the aggregate text and select 'Format' from the context menu. This opens the 'Format' dialog box. (See Format Dialog Box for more information about the available options.)

10. (Optional) To format the aggregate bar, right-click on the aggregate bar and select 'Format' from the context menu. This opens the 'Format' dialog box. (See Format Dialog Box for more information about the available options.)

<< 6.1.3 Changing the Column Layout in a Selection List © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2 Selection Tree >>