Creating Matrix Layouts
To create a matrix layout in PS/nVision:
Create a new layout by selecting
from the nVision menu.Enter a name for your layout.
It is saved as an XNV file.
Enter descriptive titles as appropriate in the rows and columns that you plan to use.
These titles are not required, but they can be helpful to mark the rows and columns for which you will define criteria.
Select
to display the PeopleSoft nVision Layout Options dialog box.Define your layout as a matrix layout and define prompting options.
Click the OK button.
Open a criteria row and column by selecting
Place your cursor in the cell where you want to add criteria.
Double-click the cell or select
to display the PeopleSoft nVision Layout Definition dialog box.Add criteria to the layout.
The type of criteria you define determine the tabs on the PeopleSoft nVision Layout Definition dialog box you use. Add worksheet-level criteria first. This always is cell A1.
To add row criteria, place your cursor on column A, rows 2 through xxx.
To add column criteria, place your cursor on row 1, columns B through xxx.
To add cell criteria, place your cursor anywhere within the spreadsheet that you want the result to appear.
Note: As you create a matrix layout, occasionally run a report request based on the layout to ensure that the layout will work as you expect.