Treetable with group and filters

Webix JS
1

Dear all,
we would like use a treetable with a grouping function and filter.
Here the pseudocode to configure the widget:

{
 
 view:"treetable",

  scheme:{

    $group:{

      by: "article",

      map:{

        meanvalue:  ["coefficient", "avg"],

        }

     }

   }

  columns:[

    { id: "article"',  header:["Article"]},   

    { id: "description", header:["Description",  {content:"textFilter"}]},   

    { id: "coefficient",  header:["Coeff."]},

  ]

 }

When we apply the filter to the treetable the rows are correctly filtered, but the aggregate value (i.e. ‘meanvalue’) is not updated.

I cannot figure out if it is a webix’s bug or an error in our code.

any suggestions, working examples or snippets?

thanks in advance

2

Hello,

It’s not a bug nor an error, as the $group key provides the static initial grouping.

Actually, it’s a quite complex task and there’s no ready solution. Only the Pivot Table includes such feature:

http://webix.com/snippet/5f4677dd