View Options

Expand to display the view options.

Field or Control	Description
Default View	Define Pivot Grid view options for the grid and the chart. Available options are: Pivot Grid Only Chart Only Pivot Grid and Chart
Grid Axis and Chart Axis	Select the initial grid and chart layout. Note that: Both grid and chart axes must be selected, irrespective of the display option selected. Both grid and chart have the same filters. All the Value type columns lie on one axis in the pivot grid. For the chart, Axis type members can be selected as X axis and Series, whereas the Value type members can be selected as Y axis and overlay. You can select only one X-axis or one overlay member. You can set multiple columns as Y axes, and these Y axes will be plotted as series on the charts. This feature has these limitations: Multiple Y axes are solely available for the Chart-only models. The X axis and series of the Pivot Grid and Chart models are determined by the dynamic grid layout. Note that it is not possible to have multiple Y axes because multiple Y axes and chart series behave in the same way. At any given point, only one Y axis and series can be plotted on the chart. If multiple Y axes are set for a Pivot Grid and Chart model, only the first Y axis is plotted on the chart. If two or more Y axes are selected on the chart, all Series values will not be applied because both X axis Series and multiple Y axes cannot be plotted simultaneously on the chart. A maximum of 10 Y axes can be simultaneously plotted on a chart. As with Series, the colors of multiple Y axes are determined by the default colors set in the PeopleSoft Charting stylesheet. To change color options, see Configuring Chart Color Selecting multiple Y axes will not automatically alter the title of the Y axis. You can change the title manually. Also, to distinguish among the different Y axes being plotted, Oracle PeopleSoft recommends that you set legends (using the Legend dropdown list in the Chart Options section) for each Y axis when you have multiple Y axes. Note: The behavior of the Multiple Y axes feature applies to both classic and fluid views. In addition for fluid viewer, you have the option to control the behavior when you select facts in the column area that are displayed in the fluid viewer. See Fluid Mode Options.
Display As	The Display As column is available only for number (facts) fields. Select either the Percentage or the Percentage Grand Total option to display the number (fact) values in the grid and chart. Select display as Percentage if you want to show the data point in percentage. Select display as Percentage Grand Total if you want to show the calculated percentage of the data point on the grand total of the field.
Dual Y-axis	This option is available for the columns that are set to Y axis. Select an option to set the corresponding Y axis column as a dual Y axis on the Pivot Grid charts; this means that the system will display a second Y axis on the chart. The values for the second Y axis will be plotted like a series on the chart. Note that: Only one column can be set and plotted as the dual Y axis on the chart. If a dual Y axis is selected to be plotted on the chart, other Series and axis values cannot be plotted on the chart. You can select multiple Y axes for a chart, and you can mark one of the selected Y axes (that belongs to the multiple Y axes) as dual Y axis for the chart. Dual Y axis is solely available for the Chart-only models. The X axis and Series of the Pivot Grid and Chart models are determined by the dynamic grid layout, so it is not necessary to have the dual Y axes as Series on the chart. If dual Y axes are set for a Pivot Grid and Chart model, only the first Y axis is plotted on the chart. The title of the dual Y axis is populated based on the name of the axis column. Note: The behavior of the Dual Y axis feature applies to both classic and fluid views.
Define Threshold	Click to access the Configure Thresholds page, where you can configure the basic threshold settings for the grids and the charts. All threshold settings are applied for both classic and fluid views. For detailed description see, Configuring Thresholds.
Next	Click to advance the wizard to the next page.