How to get cell hierarchical path in pivot table

Webix JS
#1

For example, we select 2 fields to be rows in the pivot configuration, then the pivot table should show a hierarchical tree view as below:

USA         200
     West   150
     East    50
Canada      400
     West   375
     East    25

Once I select the 50 (USA - East) in the pivot table, I should know the hierarchical path like USA - East. Is there any event/method that I can achieve this? Thanks in advance.

#2

As the inner datatable of the Pivot ($$('pivot').$$('data') ) provides access to the aggregated dataset, you can catch Pivot’s onItemClick event and get all needed information by item’s ID:

http://webix.com/snippet/c401a76d

#3

Thanks for your response. It’s very helpful!