This topic describes how to create a pivot grid view in the Aptify web interface.
The following steps describe how to create a pivot grid:
Click the Filters tab to specify filter criteria for the view. See Defining View Filters for instructions on creating filter statements.
Pivot grid views do not support multiple currencies in a single view. Any pivot grids that will include money-based data will need to be filtered to a single currency. The following limitations apply when creating pivot grids with money-based data:
|
Any other type of prompt view filter can be used in pivot grid views. |
If you want to modify the SQL statement that defines the information available in the pivot grid, click the Advanced > SQL tab and edit the SQL statement as needed. See Editing the SQL for Views for details.
If you want to schedule this view to be run automatically, click the Scheduling tab and enter the desired settings. See Scheduling a View to Run Automatically for details.