Pivot mode Issue- Grouping

[EPM Solutions]

Hello Team,

                We have requiretment to change grouping option dynamically using dropdown.

It is working fine in Non-Pivot mode but seems it is not working for Pivot Mode.

Also, after Pivot mode on and off it stops working for Non-Pivot Mode as well.

We create a plunker for better understanding. Please check and give your feedback asap.

https://next.plnkr.co/edit/SppPfMTgEyj1Mvg9?preview

Thanks.

[paramvir]

Dropdown listener is incorrect in your code.

Please correct it as below.

Code: [Select]

{
            type: 'select',           
            listener:function(evt){             
              this.Group().option({
                dataIndx:$(evt.target).val()? [$(evt.target).val()]: []
              })
            },
            options: [{
                '':'',
                'division': 'Division',
                'Budget_x0020_Year': 'Budget Year'
            }]
}

https://stackblitz.com/edit/paramquery-pivot?file=index.js

[EPM Solutions]

Hello Team,

Thanks for your quick and valuable reply. We tried your suggestion in our code and it is working fine.

But now Grouping is not coming in Sorted order.

Please check below image for reference.

[paramvir]

Please remove sortable: false from column definition and click on header cell to sort it.