ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: sshede on September 15, 2021, 06:57:58 pm

Title: Hide Total value of column for group row
Post by: sshede on September 15, 2021, 06:57:58 pm

Below Exmple group total value hide when group is open.
and pivot mode is on off then group total value show
 
https://paramquery.com/pro/demos77/pivot

Set
Page load =  pivot: false

Title: Re: Hide Total value of column for group row
Post by: paramvir on September 15, 2021, 10:32:28 pm

Please use groupModel.pivotColsTotal = hideifOpen value.

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

Title: Re: Hide Total value of column for group row
Post by: sshede on September 16, 2021, 11:41:20 am

I use bit not working.
Can you give working example.

Title: Re: Hide Total value of column for group row
Post by: paramvir on September 16, 2021, 08:57:19 pm

Sorry, please ignore my previous reply as I misunderstood your question.

Please use render callback in a column to hide total value in aggregate cell when corresponding group title row is expanded.

Code: [Select]

            {title: "Gold", dataIndx: "gold", width: 100, dataType:'integer',
                tpCls: 'gold',denyGroup: true, denyPivot: true,
render: function(ui){
var rd = ui.rowData;
if( !rd.pq_close ){
return {text: ""};
}
}
            },