Hello, pivot looks great but… Can I see detail records by clicking on any number? I mean just like the doble click in Excel pivot tables in order to see what are the records generating the cell result.
Thanks!
Hello, pivot looks great but… Can I see detail records by clicking on any number? I mean just like the doble click in Excel pivot tables in order to see what are the records generating the cell result.
Thanks!
Hello,
Here is how you can set events (onItemClick in the example) for DataTable of Pivot:
...
view: "pivot",
datatable:{
on:{
onItemClick: function(id){
var data = this.getItem(id);
console.log(data);
}
}
},
...
Your sample shows “undefined”
in order to see what are the records generating the cell result
It requires a bit more complicated code, check the full snippet in the docs
https://docs.webix.com/pivot__configuration.html#accessingrawdata