How to show and hide sub Total and grand Total in pivot grid

[EPM Solutions]

Hello Team ,

Can you provide to me solution of how to show/hide sub total and grand total when Grand Total check box checked then show grand total,

When Sub Total check box checked then show sub total to the pivot grid.

please go through the below plunker URL -

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


Please provide solution as soon as possible of it we have urgent requirements.

Also find the attached screenshot of it.

[paramvir]

Pivot subtotals and grand total are not separately configurable, there is a common groupModel.pivotColsTotal property to show/ hide both of them together.

Code: [Select]

        {
          type:'checkbox',
          label:'Totals',
          value: true,
          listener: function(evt){
            this.Group().option({
              pivotColsTotal: evt.target.checked? 'after': ''
            })
          }
        }

https://next.plnkr.co/edit/TRA4gfEQ0Zx3kZ7S

https://paramquery.com/pro/api#option-groupModel