Oracle CRM On Demand Dashboards- P9: There are many people I would like to thank as I sit here after having just penned the final chapter of this book. I am sure I will miss many specific people if I tried to list them all, but I am compelled to mention some specific supporters. | Chapter 6 Displaying Reports on the Dashboard 137 Formatting Columns in the Pages Area Columns that you add to the Pages area control the content of the page selector drop-down list. This area uses column values in a very different way than the other areas so it stands to reason that the options on the columns here are a little different too. In the More Options menu of columns in the Pages area you will find some of the same options but the effects are unique. The Hidden option hides the column values just like in other areas but since the column values in the Pages area are displayed in a drop-down list the application of the effect is rather counterproductive. Since the combination of column values determines the content of the page selector hiding one of the columns causes repeating values in the drop-down list. I have never needed to do this. If you are creating a separate drop-down list for each column hiding a column results in an error as you must display at least one value per drop-down list. When you add multiple columns to the Pages area it is the combination of these columns that determines what the pivot table page contains. Each unique combination of column values from each column results in a separate page. The column headings are initially displayed on a single line separated by a hyphen and the values on the single drop-down list are also hyphenated. To create a new drop-down list for each column click the More Options button on the column and select the Start New Page Dropdown option. A new drop-down list for the column appears on the next line in the Pages area of the pivot table. As with the other areas you will find the New Calculated Item option on your More Options menu for the columns in the Pages area. The New Calculated Item gives us the same flexibility here as in the other area only the values appear in the drop-down lists. You can use calculated items in the Pages area to filter out pages or group data into single pages. The process for
