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:
Key figure (percentage)
Division into groups is performed by treating the key figures as percentage proportions of the overall total. 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.
Key figure (absolute)
Division into groups is performed by treating the key figures as absolute values. Two limiting values must be specified: the limiting value between the A and B segments and the limiting value between the B and C segments. The data records are then assigned to the individual segments using these limiting values.
Characteristics (percentage)
Division into groups is performed by treating the number of data records as percentage proportions of the overall total. 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.
Characteristics (absolute)
Division into groups is performed by using a fixed number of data records. 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.
The following interactive functions are available for the results list of the ABC analysis: