Is it possible to make the grouping in tree view structure

[EPM Solutions]

Hi Team,

I would like to make the grouping similar to attached screen shot is that possible to achieve in paramquery?

[paramvir]

Yes, row grouping is supported upto any number of levels in Paramquery.

Example: https://paramquery.com/pro/demos/group_rows

Either drag the column titles to group header or pre-define grouped columns as dataIndx property in groupModel.

[EPM Solutions]

Hi,

Yes I am aware that we can apply grouping on multiple columns but my question is can we make the grouping structure like tree view withing one column refer my excel report screen shot again.

Best Regards,
Pankaj Srivastava

[paramvir]

grouping titles can be made to appear in single column by

1. hiding the grouped columns ( add hidden: true to grouped columns )

https://paramquery.com/pro/api#option-column-hidden

and

2. add summaryInTitleRow: '' to groupModel.

https://paramquery.com/pro/api#option-GM-summaryInTitleRow

[EPM Solutions]

This is not seems to be the right approach we can not hide the columns. after hiding our columns data are not appearing. Is there any other method to merge three column header in one column header ?

[paramvir]

groupby columns have repetitive data anyway, so if a value is displayed x number of times it's displayed only once in the group title when groupby column is hidden.

Please check this example: https://paramquery.com/pro/demos/group_rows_hidden

[EPM Solutions]

Hi Thanks for your support much appreciated !!

How can I enable the filter option if columns are hidden ??

Filter options are also hidden after hiding the columns can we display the filter option if columns are hidden?

[paramvir]

Filter options for hidden columns can be displayed in toolbar.

[EPM Solutions]

Hi toolbar filter are completely different(conditional) than columns filter.. I want to integrate the same as columns dropdown filter after hiding the columns, filters are disappeared how can I get it back??

if my columns are hidden can we position hidden column filter dropdown in different columns or somewhere else in header ?

[EPM Solutions]

Hi Thanks for your help much appreciated !!

I have achieved the filter functionality from toolbar.


Best Regards,
Pankaj Srivastava