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
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
Hello,
Here is how you can set events (onItemClick in the example) for DataTable of Pivot:
Your sample shows "undefined"
It requires a bit more complicated code, check the full snippet in the docs
https://docs.webix.com/pivot__configuration.html#accessingrawdata