Expand/Collapse Columns in Pivot Table

Webix JS
#1

Hi, I am new to this library and I am using the Pivot widget.

In my Pivot table everything works fine, I can expand/colapse rows, use filters, etc, but I wanted to know if it is possible to expand/colapse columns also.

For example, my columns are “Years” and “Months” and I want to expand/colapse the years in order to see or not the months details.

Is that possible, if so, how?

Thanks in advance.

#2

This question can be easily answered with a YES or NO. Really there’s no one from the staff who can reply this?

I am testing a few different libraries to show Pivot Tables in my website, I liked this one but I can’t use it if it doesn’t have the feature to collapse columns.

I would appreciate an answer.

#3

if it is possible to expand/colapse columns also.

You can do it with raw datatable, there is no build-in option in the pivot to enable such functionality though. Which means, it can be added but will require a pivot customization ( adding a custom handler before data rendering, which will alter column’s configuration in the necessary way )

http://docs.webix.com/datatable__columns_configuration.html#groupingcolumns

http://docs.webix.com/pivot__customization.html#prerendercustomization