ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on December 12, 2019, 06:09:38 pm

Title: How to show and hide sub Total and grand Total in pivot grid
Post by: EPM Solutions on December 12, 2019, 06:09:38 pm

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.

Title: Re: How to show and hide sub Total and grand Total in pivot grid
Post by: paramvir on December 12, 2019, 09:18:31 pm

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