Using the Pivot Tool With Active Technologies Reports for Adobe Flash Player

How to:

Reference:

Pivot Tables reorganize and summarize selected columns and rows of data in order for you to obtain a desired report.

By default, a Pivot Table groups the selected column as the vertical sort field and the selected row as the horizontal sort field. The Pivot Tool enables you to select multiple group fields in the Pivot Table generated.

The Pivot Tool contains a list of columns available in the active report and Group By, Across, and Measure sort fields. Click and drag the columns into the desired sort field.


Top of page

x
Procedure: How to Use the Pivot Tool With Active Technologies Reports for Adobe Flash Player
  1. Create an active report with an output format of either active report for Adobe Flash Player (FLEX) or active report for PDF (APDF). In the following image, active report for Flash is selected from the output format drop-down list on the Report Painter toolbar.

  2. Run the active report.
  3. In any column heading, click an arrow to display a drop-down menu. From the menu, click Pivot Tool, as shown in the following image.

    Selecting the Pivot Tool

    The Pivot Tool opens, as shown in the following image.

  4. Left-click and drag the desired columns into the Group By, Across, and Measure sort fields.

    You must include a column in the Group By and Measure sort fields (a Measure typically defines how much or how many). The Across sort field is optional.

    In the following example, Product and Category are the Group By sort fields, Region is the Across sort field, and Dollar Sales is the Measure field.

    Pivot Tool Display Columns

  5. You can edit the sort fields by clicking the X icon to delete columns, drag multiple columns into the Group By or Across sort fields, reorder the columns in the sort fields, and change the aggregation type of the Measure by clicking the Calculation icon.

    You cannot use multiple Measures.

  6. The Pivot Table is generated in a new window based on the sort fields selected, as shown in the following image.

    Pivot Table

  7. Click the close button, X, in the upper-right corner of the Pivot Tool to exit the tool.
  8. You can click the Menu icon on the Pivot Table toolbar, and click Pivot Tool, to open the Pivot Tool again.

    Alternate Pivot Tool Selection

    On the Pivot Table toolbar, you can optionally lock (freeze) the table by clicking the Lock icon, or change the aggregation type by clicking the Calculation icon.


Top of page

x
Reference: Pivot Tool Usage Notes

The following apply when you use the Pivot Tool in an active report for Adobe Flash Player format:


WebFOCUS