Add a filter for Pivot Grid that will work similar to flex grid filters

Posted by: sskss1ss2 on 13 January 2022, 4:50 pm EST

  • Posted 13 January 2022, 4:50 pm EST

    Hello,

    I am trying to add a filter functionality that'll work similar to flex grid filters. I am trying to use "wj-flex-grid-filter" in Pivot. With this introduced, the filter works fine for column fields. But it breaks / disappears once i click on the RowFields column.
    How should i approach this problem?

    Thanks
  • Replied 17 January 2022, 4:07 am EST

    Hi,
    Could you please elaborate on your requirement for adding the filter for Columns on PivotGrid? Since the observed behavior is by design. As the Row/Column fields are changed the PivotGrid calculates all the data again. Hence the filter gets cleared.

    You may go with the Slicer instead of the column filter. Please refer to the following demo sample for reference:
    https://www.grapecity.com/wijmo/demos/OLAP/Slicer/purejs

    Hope it helps!

    Regards,
    Manish Gupta
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels