#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
• 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
No comments:
Post a Comment