A paged workbook is used to save the view of the data in different pages for different values of the dimension or measure. A common example is to see how each type of products have performed against each other in a specific sales region. As each of the values of product type is stored as a separate page, we can view them one at a time or see it as a range of values.
Creating Paged Workbook
The paged workbook contains worksheets which have fields put in the page shelf. Consider an example of studying the profit of various sub-category of products in different regions. Following are the steps.
Step 1 − Create a bar chart with two dimensions and one measure. In this case, drag the Measure Profit to the columns shelf and the dimensions sub-category, and Region to the rows shelf as shown in the following screenshot.
Step 2 − Drag the Sub-Category field again to the page shelf. You will see that a page control is automatically added, just below the Pages shelf. This page control provides the following features to navigate through the pages in a view −
- Jump to a specific page
- Manually advance through the pages
- Automatically advance through pages
In this case, we will see how to jump to a specific page and how to get the automatic display of pages. To go to a specific page, click on the drop-down on the page control and select Accessories. The chart seen in the following screenshot appears.
Step 3 − For automatic display of pages, keep the show history checkbox ticked and click the play button. You can then see an automatic play of different pages of sub categories. While the current Sub-Category value is shown with a dark color, the previous values are shaded with light color. The following screenshot illustrates this.