When you call the ABC Analysis function , the column from which the key figures are taken is determined first. The actual data that is used depends on whether you called the ABC Analysis function from the list or from the table ( Display as Table).
Determine the key figures for which you want to run the ABC analysis.
Calling from the list display
Position the cursor on the column whose values are to be used as key figures. If you have placed the cursor on a non-numeric column then the next numeric column will be used.
The ABC analysis cannot be carried out for additional fields in statistics and ranked lists (number of records read, percentage of total, average value, position in sequence).
Calling from the table display
Select the column whose values are to be used as key figures.
All non-numeric values to the left of the key figure are regarded as characteristics. This is especially important when the analysis is called from the table display, since columns can moved around in this display and it is therefore possible to change the number of values regarded as characteristics.
A dialog box opens in which you determine the direction you want to sort the key figures (ascending, descending) and the analysis strategy. This window also contains the names of the fields which are to be used for the key figure and the characteristics.
The analysis strategy is defined in two steps:
Select the strategy required using a selection button (see above).
Supply the other information required to implement the chosen strategy (percentages, boundary values or numbers of data records, as required in the strategy). Only two pieces of information are required for percentage shares or number of data records. The third piece of information is calculated from the other two.
If the key figure is a currency field or quantity field, then a check is made in single line basic lists that the currencies or quantities have been specified in the same currency or unit of measurement. This check can be made only if the currency or unit of measurement is also output in the list. When different currencies or units of measurement are present, these are first converted into a reference currency or unit of measurement. This reference currency or unit of measurement can be entered in a dialog window. If errors occur in the conversion, then the ABC analysis cannot be carried out.
The result of the ABC analysis is a list. The first column of this list shows one of the segments (A, B, or C). Then come the characteristics and finally the key figure. After each key figure the percentage share of that key figure on the total is shown, along with the cumulative percentage share. In addition, the list contains the total and the subtotals for the segments and for the totals of the A and B segment and for the B and C segment.
The following interactive functions are available for the results list of the ABC analysis: