Use

You can set-up an ABC Analysis for every interactive basic list, every statistic, and every ranked list containing at least one numeric field.

For the ABC analysis the data records of a dataset are divided into three groups (A segment, B segment, C segment). Each of the data records must include a key figure (a numeric field) and an arbitrary number of other characteristics (non-numeric fields). The dataset is initially sorted on the key figure in either descending or ascending order. There are four ways of dividing the data records into groups:

The data records are divided into groups according to the size of the partial sum of the key figures considered as a percentage of the sum of all the key figures. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A as long as the sum of the key figures does not exceed 50% of the total. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.

The data records are divided into groups on the basis of the absolute values of the key figures. Two boundary values have to be specified, one to mark the boundary between the A and B segments, and one to mark the boundary between the B and C segments. These boundary values are used to determine the segment to which each data record should be allocated.

The data records are divided into groups so that a specific percentage of the data records are allocated to each group. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A until 50% of the total number of data records have been allocated. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.

A specific number of data records are allocated to each group. For example, if the following distribution is chosen: A=10, B=20 and C=... , then the first 10 data records are allocated to segment A, the next 20 to segment B and all remaining data records are allocated to segment C.

Activities

Calling the ABC Analysis

The following interactive functions are available for the results list of the ABC analysis.