Previous page Next page

Configure the Pivot widget as follows:

  1. Configure common parameters (see Common widget settings).

  2. Select the field that will be in the table rows (1).

  3. Select the field that will be in the table columns (2).

  4. If non-numeric fields are selected, then in the Value function field, select count (3). This parameter will count the number of events. If a numeric field is selected, then you can select the sum, average, minimum and maximum value.
  5. If the summary table has many columns and it is necessary to freeze the first column when scrolling through it, then activate the Fixed 1 column parameter (4).

  6. If necessary, configure the column with the difference in the values ​​of other columns. To do this:

    1. Activate the Delta column parameter (5).

    2. Enter the column name (6).

    3. To display only this column in the table, set the Hide others checkbox (7).

    4. In lists A and B, select the columns, between the values ​​of which you want to calculate the difference (8).

  7. To highlight a row in red when the specified conditions are met, do the following:

    1. Activate the Highlight row if parameter (9).

    2. Select the column which value will be compared with the reference value (10).

    3. Select the operation (11).

    4. Set the reference value (12).

  8. Click Save.

The Pivot widget is configured.

  • No labels