Start of Content Area

Example Sorting: Example 2  Locate the document in its SAP Library structure

Use

The following example demonstrates how you can use local fields with calculations which depend on conditions in a sorted statistic. The statistic contains quarterly sales figures of individual airline carriers for a year which you specify on the selection screen.

Prerequisites

Procedure

  1. On the Field Selection screen, define the local fields as shown in the following illustration (see also Assigning Short Descriptions and Defining Local Fields):

    2. This graphic is explained in the accompanying text

    The field Year is a local field which you specify on the selection screen. Its value determines the year for which quarterly sales figures are required.

    This graphic is explained in the accompanying text

    There are two things to take into account with the fields for quarterly sales figures. The InfoSet retrieves per flight (flight date) the total existing bookings. Using the flight date, you can thus determine to which quarter this total is to be assigned. Furthermore, only the quarters of a pregiven year should be determined according to the task. A quarterly sales figure is, therefore, the same as the booking total if the flight data lies in the pregiven year and in the correct quarter. As an example, we can use the definition of the field for bookings in the 2nd quarter.

    This graphic is explained in the accompanying text

    Note that this example uses a replacement variable (&Y) in the column header.

  2. Once you have defined all local fields, change to the Statistics screen sequence by clicking on the Statistics pushbutton.
  3. Choose Next Statistic to define a new statistic

    4. Define the statistic as shown in the following illustration:

    This graphic is explained in the accompanying text

  4. Use the Test This graphic is explained in the accompanying text function to test the query.

Result

The following list is displayed:

This graphic is explained in the accompanying text

 

 

End of Content Area