3.Creation of Workbooks using Page-detail and Cross tab.

#This chapter explains how to create Workbook using Page details and Cross tab.

• Build a new workbook or worksheet
• Edit a worksheet:

Select the type of display for the new worksheet or workbook:

• Table: Table output has columns of information with headings
• Crosstab: It is also called as drill down approach.Crosstab output looks like a bus or train timetable with values displayed across the top, down the left edge and in the intersection of rows and columns.

• Normal tables have selected items across the top
• Crosstabs have items across the top and items down the side

                Values are shown in the grid
                Some kind of aggregate (sum, count, etc.) if necessary

• Page Items are also useful for filtering data

Example:

• Page-Detail: A page detail layout is a table or crosstab report produced for each value of the page item,such as an account.

Sample Page Item


 Select the data that belongs on the worksheet in the workbook