ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on October 22, 2019, 08:21:31 am

Title: How can we hide/show the aggregate columns of pivot grid ?
Post by: EPM Solutions on October 22, 2019, 08:21:31 am

Hi Team,

Can you tell me a way that how can we hide/show the aggregate column of a pivot grid?

The below image is showing the aggregate columns.

Title: Re: How can we hide/show the aggregate columns of pivot grid ?
Post by: paramvir on October 22, 2019, 01:07:56 pm

Aggregate column in pivot grid can't be hidden.

However you can make it effectively invisible by adding this to the column.

Code: [Select]

minWidth:1, maxWidth:1, resizable: false,


Title: Re: How can we hide/show the aggregate columns of pivot grid ?
Post by: EPM Solutions on October 24, 2019, 12:11:59 pm

Hi Team,

Thanks,

We have requirement to show/Hide aggregation subtotal and total column in pivot mode. This is required feature and there is no option we found to do it same.

Can you please add this feature in library and let us know expected date for this feature?

The Total and Sub Totals are highlighted in below screenshot.

Title: Re: How can we hide/show the aggregate columns of pivot grid ?
Post by: paramvir on October 24, 2019, 12:35:40 pm

Please set groupModel.pivotColsTotal = "hideifOpen" to show/hide aggregate columns in your screenshot.

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

Title: Re: How can we hide/show the aggregate columns of pivot grid ?
Post by: EPM Solutions on November 13, 2019, 09:11:16 pm

Hi Team,

Thank you for your quick reply.

Actually our requirement is to hide and show the Sub Total column/aggregate column inside collapsible column of a pivot grid on selecting/unselecting checkbox(SubTotal).

Please tell me the solution. or Can you please add this feature in library and let us know expected date for this feature?

The problem code URL  given below

Problem jsfiddle URL:
https://jsfiddle.net/mua79tcs/