Data detail in pivot table

Webix JS
#1

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!

#2

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);
		}
	}
},
...
#3

Your sample shows “undefined”

#4

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