Grouping Data by Page: Page-by

When you have a very large set of data on a report, it can be easier to work with that data by grouping it into logical subsets, and viewing only one of the subsets at a time. To group data into subsets, you can

use the page-by feature. The subsets you separate your business data into are called pages, and you then page your way through the report, one data subset at a time.

Attributes and metrics are the most common objects used in the page-by area of a report, although you can enable page-by for most objects that appear on a report. You can page-by any of the following

objects:

Attributes
Metrics
Hierarchies
Consolidations and custom groups.

You can page by most object prompts, specifically, object prompts that are made up of attributes, hierarchies, consolidations, and custom groups. Object prompts containing metrics can be placed in the page-by area as long as the report’s rows or columns do not contain a metric. You can drill on an attribute or compound metric within the Page-by axis. For more information, see Drilling on a grid report.

This procedure assumes that Page-by is enabled. Page-by can be enabled or disabled by your administrator.

You can place more than one object in the page-by area. If you decide to place multiple related attributes in the page-by area, be aware that order matters. Whatever you page-by first (furthest to the left) affects

the elements displayed in the other page-by fields. Place multiple objects into the page-by area in logical order, from left to right.

To move an object to the Page-by area:

Run a report.
From the Tools menu, select Page-by Axis.
Right-click the object's header in the report, select Move, and then select To Page-by Axis .
The report is automatically re-displayed to show only the subset of data reflecting the current Page- by field. Select an option from the page-by field's drop-down list to change the subset of data displayed.
You can reposition the objects in the Page-by area. Right-click the object on the Page-by area, select Move, and then select To Columns or To Rows, as necessary.