Pivot - unlimited tree

Webix JS
1

Hi,

Is to possible to make unlimited tree with the Pivot component for the id / parent Id data? May be there is a way to build that tree
programmatically?

For example we have “fruits” table.

id | parentId | Name | Quantity |

1 | null | Fruits | null |

2 | 1 | Small | null |

3 | 2 | Apple | 5 |

4 | 2 | Banana | 2 |

5 | 1 | Big | null |

6 | 5 | Melon| 3 |
…

Than it would be great to have a tree, like:

Fruits = 10

–Small = 7

----Apple = 5

----Banana = 2

–Big = 3

----Melon= 3

Thank you.

2

I don’t see how it applicable to the pivot.
In case of common webix components - you can load the plain data and group it as a tree
http://docs.webix.com/datatree__loading_data.html#loadingplainlistlikedata

3

Ok, I see :slight_smile:

This option would be very useful in financial analysis when the data structure contains different hierarchical references.

Аnyway Pivot component is excellent. Thank you, Maxim.