Aligning the Text in a Grid

To align the text in a grid:

1. Open a report and select a cell or cells in a grid.
2. Select Format, and then Cells.
3. In the Format Cells dialog box, in the Alignment tab, define the following options:

   • Horizontal—Horizontal alignment in the report.

   • Vertical—Vertical alignment in the report.

   • Indent—Number of spaces to indent the heading and the associated text, data, and formula cells from the left margin.

   • Indent Increases for Each Generation By—Amount by which the indent increases for each generation of a member.

     This option is enabled only for member rows and member selections that use member selection functions (for example "Children(East)" or "Descendents (Market)"). If you have an individual selection (for example "East" or "West"), you cannot define a value.

     The indentation is done on the member’s "generation", which is a number that denotes its hierarchy position from left to right. A dimension parent is Generation 1, and its children are Generation 2.

     To indent the row headings for each generation of a selected member:

     1. Confirm that you selected a row with the desired heading cell.

     2. Select the number of spaces to indent the text.

        This number is added to the number defined in Indent. To specify a reverse indentation (from right to left), enter a negative number.

        Select a member relationship that returns members on multiple levels; for example: Children of ...(Inclusive), Descendants of..., Descendants of ...(Inclusive), Parents of...(Inclusive), Ancestors of, Ancestors of...(Inclusive), and AllMembers.

4. Click Apply, and then OK.