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

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).

See also
Back to top