Distribution

Distribution enables the user to keep a set of values in the table, which constitute certain percent (or number) of the total sum. Remaining values will be aggregated into one element.

Distribution is available only for values in one column or in one row of the table. If distribution for other table column or row is set up, the current distribution will be canceled.

Distribution is set by the number, percentage or sum for top or bottom elements:

The example of a table with distribution:

Setting Up Distribution

To choose the column or row, for which distribution will be applied:

If one cell is selected, distribution will be applied for the column containing the cell.

To set up distribution for the selected data range, click the Distribution button on the Designer ribbon tab, select distribution method in the drop-down menu:

Distribution by set parameters

Distribution by custom parameters

Simultaneous distribution of top N and bottom N

Disable distribution

Aggregation of Remaining Elements

Table elements, which do not correspond to distribution condition, will be aggregated and displayed in the Others separate element.

Remaining elements will be summed up by default.

To change aggregation method of remaining elements, execute the following operations:

  1. Select row or column with the Others item.

  2. Go to the Distribution side panel tab on the Format tab group.

  3. Select aggregation method of elements.

See also:

Table Data Analysis