Hi,
I have a pivot table with aggregate values in it :
var fields = [
{ id: "a", value: "A", type: "text"},
{ id: "b", value: "B", type: "text"},
{ id: "c", value: "C", type: "text"},
{ id: "d", value: "D", type: "text"},
{ id: "e", value: "E", type: "text"},
{ id: "f", value: "F", type: "text"},
{ id: "g", value: "G", type: "text"},
{ id: "x", value: "X", type: "text"},
{ id: "y", value: "Y", type: "text"},
{ id: "z", value: "Z", type: "text"},
];
webix.ui({
container: "pivot-container",
rows: [
{
view: "pivot",
id: "pivot",
url: checkedDataUrl,
fields: fields,
structure: {
rows: ["x", "y", "z"],
columns: [],
values: [
{ name: "a", operation: ["countunique"], format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 0 }) },
{ name: "b", operation: ["sum"], format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 2, priceTemplate: "€ {obj}" }) },
{ name: "c", operation: ["sum"] , format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 0 }) },
{ name: "d", operation: ["sum"] , format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 0 }) },
{ name: "e", operation: ["sum"], format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 0 }) },
{ name: ["f", "g"], operation: ["ratiopercent"] , format: webix.Number.numToStr({ decimalDelimiter: ",", decimalSize: 2, priceTemplate: "{obj} %" }) },
],
filters: [{ name: "b" }, { name: "c" }],
}
]
})
Is there a way for the filters to operate on the aggregate values instead of on the raw data fields?
Kind regards,
Nick