How can we hide/show the aggregate columns of pivot grid ?

[EPM Solutions]

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.

[paramvir]

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,


[EPM Solutions]

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.

[paramvir]

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

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

[EPM Solutions]

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/