Grid settings

Setting

Explanation

Grid Type

Click on this section to select a row and column layout for the grid.

Show Grid Toolbar

Optionally, clear this option to remove the paging toolbar from the bottom of a widget with multiple pages of data. Clearing this option may be useful when creating simplified widgets.

Hide Grid Totals

This option allows you to hide or show the totals row. Users can also click on the Total and Average rows in the grid to toggle these rows on/off.

Hide Grid Averages

This option allows you to hide or show an average row. Users can also click on the Total and Average rows in the grid to toggle these rows on/off.

Hide Grid Subtotals

This option allows you to hide or show a row showing the subtotal for checked members.

Grid Page Size

Enter the maximum number of members to display.

• For the top-level dimension (1st By), the widget will show up to this number of members per page. If the context exceeds this number, users will be able to navigate to additional pages using buttons at the bottom of the widget.

• For lower-level dimensions (2nd By, 3rd By, etc.), a standard grid will show up to this number of members when the parent level is expanded. Additional members beyond this number will be truncated. Because multiple levels and multiple members in each level may be expanded, the actual number of rows can exceed the grid page size.

You cannot increase the grid page size beyond the maximum number set by your administrator.

Number of rows to expand

Optionally, enter a number greater than zero to automatically expand the top row(s) into an additional level of data (i.e., 2nd By). The specified number controls how many rows will be expanded on each page. Additional rows may be expanded as usual.

Column Page Size

(Crosstab only) Enter the maximum number of Cross By members, or columns, to show. Users will not be able to access Cross By members beyond this number.