datatable

defines configuration for the Pivot inner grid

object datatable;

Example

webix.ui({
  view:"pivot",
  datatable:{
    minX: true,
    maxX: true,
    footer: "sumOnly",
    rowHeight:27,
    rowLineHeight:27,
  },
  structure: {
    rows: ["form", "name"],
    columns: ["year"],
    values: [{ name: "oil", operation: ["min", "max", "sum"] }],
  },
});

Related samples

Pivot: Datatable Configuration

Details

The datatable object defines settings for the grid in the table and tree modes. Includes the following fields:

footer (boolean, string) - defines whether to show a sum of values in the column footer. Possible values are:
- true
- false (by default)
- "sumOnly" - to calculate totals only for "sum" columns.
minX (boolean) - highlights the lowest value in a row
maxX (boolean) - highlights the highest value in a row
minY (boolean) - highlights the lowest value in a column
maxY (boolean) - highlights the highest value in a column
cleanRows (boolean) - defines whether to remove repetitions of values in the first columns (in the table mode).
totalColumn (boolean, string) - defines whether to show column(s) with totals for each value. Possible values are:
- true
- false
- "sumOnly" - calculates totals only for columns the "sum" function is applied to.
transpose (boolean) - arranges math results on the row axis.

You can also apply properties of the Datatable widget to the inner Pivot grid (e.g. rowHeight as on the example above).