O'Reilly logo

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting by Yuli Vasiliev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the page items area

Often you need to select for display only part of the data you have on the worksheet. This is where the page items area above the crosstab comes in handy.

Proceeding to the example discussed here, suppose you want to select data by month, choosing a month in the items area select box. To do this, you can drag the month item from the top axis to the page items area. The following is the worksheet you should see as a result:

Using the page items areagraphdrilling from

The layout will change, of course, if you select another month from the Page Items area select box. It's interesting to note that you're not limited to a single item to be set in the Page Items area. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required