Name – Name of the level. Used in the view explorer and filter windows.

Caption Expression – A read only field that shows the expression behind the caption for a level. The resolved text generated by the expression creates the caption, which is the text that displays for the level in the view. The Caption Expression window can be accessed for editing the expression by clicking the Browse button  next to the field. Levels will be referred to by their names in all other Stratum.Viewer locations that they appear, such as in view explorer and the Select Members window.

Filter and Sort - Use to add, edit, or remove filters and sorts.

• Filter Mode – This property controls how Viewer treats a member list, user list, expression, or named set filter. The “Include” option means the applied filter returns only the members specified by your filter selections/criteria. “Exclude” means the applied filter returns all members except the ones specified by your filter selections/criteria.

• Filter - click the Browse button  to access the Select Filter Method window and either add or change a filter. If a filter already exists, the filter type displays in this field and a pop-up label shows filter criteria.

• Sort - use the list provided to add Ascending or Descending sorts or to change or remove a sort.

See also Working with Filters and Working with Sorts.

Total – Use to control whether or not Total values display for the level. When the property is Yes, totals will display for the level, When the property is No, totals will not display.

All Others – Use to control whether or not All Others values display for the level. All Others values represent the sum of all members not in a filter. When the property is Yes, All Others values will display for the level, When the property is No, All Others will not display.

Visible – Set this property to No to hide the level in a view. Set this property to Yes to display the level in a view.

Display Text – This property controls what displays in the first row or column for the level. The default is the level value. You can change it to any of the attribute relationships that have been made available in the view for the level. If no attribute relationships are available yet, see Edit Attribute Relationships.

Fill Color – Assign a fill color that will be used in the row or column containing the level. This makes it stand out from the rest of the grid. Click the Browse button  next to the Fill Color property to choose a color from the Color window. Or, if there is already a color selected and you don’t want a fill color used anymore, select the No Color checkbox.