how to get the pivot grid cell value of a group cols?

[徐雪峰]

i want to get the pivot grid cell's value of one kind of group cols.
because i want to sum them by my formular.
is there any way to do it ?

[paramvir]

pivot grid cell value can be obtained by

Code: [Select]

grid.pageData()[ rowIndx ][ dataIndx ]

However you don't need to access individual cells because custom aggregate can be conveniently written by adding a custom method to pq.aggregate

https://paramquery.com/pro/api#method-aggregate

[徐雪峰]

thank you ,i'll try it. if success, i think i will very happy.

[徐雪峰]

//define custom aggregate "all", now it can be used as column.summary.type
agg.all = function(arr, col){
    return "Sum: " + format( agg.sum(arr, col) )
        +", Max: " + format( agg.max(arr, col) )
        +", Min: " + format( agg.min(arr, col) );
};
can you tell me the meaning of paramater arr and col?

[paramvir]

Please refer API for meaning of arguments:

https://paramquery.com/pro/api#method-aggregate

[徐雪峰]

i set the pivotColsTotal: 'hideifOpen',but can not hide the last summay column.

[paramvir]

Since last summary column has no parent column, "hideifOpen" is not applicable to it.

It can be hidden in the pivotCM event by adding hidden: true property to it.

[徐雪峰]

thanks.