Author Topic: Hide Total value of column for group row  (Read 1270 times)

sshede

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 41
    • View Profile
Hide Total value of column for group row
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6307
    • View Profile
Re: Hide Total value of column for group row
« Reply #1 on: September 15, 2021, 10:32:28 pm »
Please use groupModel.pivotColsTotal = hideifOpen value.

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

sshede

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 41
    • View Profile
Re: Hide Total value of column for group row
« Reply #2 on: September 16, 2021, 11:41:20 am »
I use bit not working.
Can you give working example.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6307
    • View Profile
Re: Hide Total value of column for group row
« Reply #3 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: ""};
}
}
            },