Drilldown View – Assign a drilldown view if you want to drill from the last level displayed on rows to another view, for example, to a view with related or complimentary data to the originating view. Choose from views that you normally have access to in the application.

Repeating Values – Use to control whether or not duplicate row values display in the grid. Set the option to Yes if you want to see the following values repeated across the row detail cells in the grid: level display text, level attribute relationships, headings for All Others (if Others Summary is enabled), sub-totals, and grand totals.

Totals Default – Use to control whether or not Totals display by default for new levels inserted on rows. Leave the property set to Yes if you want all new levels that are inserted on rows to have totals displayed for them. Change to No if you want totals to be disabled for all new levels that you insert on rows. You can customize totals for new and existing levels in other ways using other settings:

• Change totals for individual levels, one level at a time. Use the "Total" setting in the Properties windows for individual levels to show or hide their totals.

• Change totals for all levels on rows at once. Use the "Totals" option on the pop-up menu for the row axis (right-click the rows axis icon ) or by right-clicking the Rows folder in view explorer. Selecting Yes from the menu displays totals for all levels on rows and sets the “Totals Default” to Yes. Selecting No hides totals for all levels on rows and sets the “Totals Default” to No.

Others Summary – Use to control whether or not All Others data displays in rows for filtered levels. Select Yes if you want the "All Others" rows to display. For example, if you have filtered a level by certain members, you could set Others Summary to Yes to see the sum of all other members not in the filter. Select No if you do not want All Others data to display.

Relationship Filter and Empty Filter – When the Relationship Filter is set to Yes, only the members that have data for the measures and time ranges defined in the view will display. When the Relationship Filter is set to No, all members will be displayed. This allows you to see members with and without data for the measures and time ranges defined in the view. You can additionally use the Empty Filter property. In order for the Empty Filter property to be set to Yes, the Relationship Filter property must be set to Yes. The empty filter will remove any rows where no data exists, but that were not removed by the relationship filter. This can occur when there is a level filter on the axis opposite the measure item axis. See also Using Relationship and Empty Filters.

Axis Filter – Use to work with an axis filter on rows:

• Click the Browse button to add or edit a filter on the rows axis. An Expression window displays for setting up the filter. A pop-up label for this field displays expression criteria for an existing filter.

• Click the "X" button to remove a filter.

See also Working with Filters and Example Expressions for Filtering an Axis.