Data detail in pivot table

darroyo

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!

Maria

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

nesd

Your sample shows "undefined"

maksim

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