Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This topic describes how to add fields to a pivot grid view. Pivot grid views are added to the Aptify web interface in Aptify 5.5.4.

A pivot grid is blank when it loads for the first time. You need to drag and drop fields to various locations to construct the table. Follow these steps after loading a new pivot grid:

  1. If not already displayed, click the Field List icon in the pivot grid toolbar to open the pivot grid Field List.This list contains The FIELDS section of the window lists all of the fields you specified for the view's entity as well as for any linked entities.
    • See the following example:
      Displaying the Field ListImage RemovedInitial Pivot Grid View SampleImage Added

  2. Select fields from the Field List FIELDS section and drag them to the various locations in the pivot grid, as desired. Note that you can stack multiple fields in the same area but you cannot add a field to more than one area of the pivot grid. The available locations include:
    • Drop Filter Fields Here: If you did not specify view filters or if you want to further refine the results in the pivot grid, you can add fields here to filter the table resultsCOLUMNS: Drop one or more fields in this area to create columns entries for the table. You can add multiple fields to create layered columns. For example, you might want to filter a table based on order date.Drop Row Fields Heredisplay order data by person based on the product that appears on an order's first order line.
    • ROWS: Drop one or more fields in this area to create row entries for the table. You As with columns, ou can add multiple fields to create layered rows. For example, you can add the Company field to the left edge of the row area and then add a Person field to the right of the company. This creates top level rows for each company in the dataset and then sub rows for each person at a particular company. See this example:
      Pivot Table with Sample FieldsImage Removed
    • Drop Column Fields Here: Drop one or more fields in this area to create columns entries for the table. As with rows, you can add multiple fields to create layered columns. For example, you might want to display order data by person based on the product that appears on an order's first order line.
    • Drop Totals or Detail Fields Here: Drop one or more fields in this area to specify the details of the report. For example, you might want to drop the Grand Total field to display the Grand Total for each order associated with a particular person and product.
       
  3. Move or rearrange fields as necessary. The Fields added to the pivot grid layout can be modified in a variety of ways. For example, they can be moved to other areas of the pivot grid, removed entirely from the pivot grid, or sorted, as described below:
    • To remove a field, select its heading click the X next to the field name in the various locations in the pivot grid. Right click the field and then select Remove Field from the pop up menu. The field is removed from the pivot grid area but remains in the Field List and can be added again later if needed.
    • Some fields can be sorted , either ascending or descendingwithin a location, depending on their location on the pivot grid. To sort a field, right click on select the field and select either Sort Ascending or Sort Descendingmove it within the location.
       
  4. Add calculations measures to the pivot grid, as desired by dropping one or more Measures sub-fields in the MEASURES location to perform calculations in the report.
    • Default data fields are Count, Sum, Min, Max, and Average.
    • Calculations can be performed on certain numeric pivot grid fields , depending on where they appear in the pivot grid (typically in the Total or Details area).To apply calculations, right click the field and select AutoCalc. Then select the appropriate calculation from the list of choices: by adding a measure to the Measures field list. 
    • Add new measures by performing the following steps:
      1. Click the MEASURES button in the view's toolbar.
      2. In the Field Name field, select the field for which you want to perform a calculation.
      3. In the Measure field, select the calculation you want to perform. The available calculations are Count, Sum, Min, Max,
      or Count. Not all choices may be available for each field.
      1. and Average.
      2. In the
      figure below, a Sum of Grand Total calculation has been added to the detail tab to add the totals from all of the displayed orders. The calculated field is added to the Field List automatically.
      Adding a Calculated FieldImage Removed
  5. Use the plus (+) and minus ( ) signs to expand and collapse items to display only specific data. These options are also available in the right click menu when you select one or more items in the table.
  6. Modify the layout for a particular field using the Command and Options dialog.
    • For example, you might want to display order totals as currency amounts (as shown below).
    • To open the dialog, either select Commands and Options... from a right click menu or click the Commands and Options icon in the pivot grid toolbar.
      Modify FormattingImage Removed
      1. Name field, enter name to be used to identify this measure in the Measures field list. 
        • A default name is automatically created in this field from the values entered in the Field Name and Measure fields.
           
      2. Click ADD to add this measure to the grid on this form.
      3. Repeat steps a through e to add additional measures.
      4. When you have finished adding measures to the grid, click ADD MEASURES to add these to the Measures field list.
  7. Use the left arrow and down arrow icons in the table to expand and collapse items to display only specific data. 
  8. Export or print the pivot grid, as needed.

 

Info

The steps above provide any an overview of the configuration options that are available when working with a pivot grid. Refer to the Microsoft Office 2003 pivot grid component's Help documentation (accessible from the Help button in the pivot grid toolbar) for more information how to use a pivot grid and the Commands and Options dialog.

Also, see See How to Create a Sample Pivot Grid in the Web Interface for instructions on how toan overview of the pivot grid view creation process.