Search This Blog

Thursday, August 2, 2012

Adding Column Totals to a Page

Telemet Orion users may total the data fields in a Custom Price Page to show a column’s maximum, sum, average or total value.

1.      To open the Set Attributes menu, choose Options>Columns> and click the Set Attributes button on the dialog window

-or-

1.                  Double click on any column heading on the Custom Price Page

2.                  Select the column you want to add a total to in the column list box.

3.                  Click on the Total Function option from the Attributes section of the Select Columns screen.  You will see a Total Function section appear on the right side of the Select Columns screen.

4.                  Click on the drop down arrow located to the right of the entry at the top of the Total Function section. You see a list of options to choose from: Text (allows you to associate a line of text at the bottom of a column of data), Sum, Minimum, Maximum, and Average. Choose the option you want.

·         The Alignment field allows you to select where the total function is aligned in the data column of the Custom Price Page. Right, Left, and Center position the data in the location of the option that you select. Choosing Decimal centers the total on the decimal place in the data field.

·         The Display When field displays the data according to the series of options that you choose. Selecting Positive, Negative, or Zero shows data when there has been positive, negative, or zero change in the data from yesterday’s close.

Note: You can-not total columns in a Custom Price page if you have selected Repeat Column Groups Across Display as an option from the Style settings.


No comments:

Post a Comment