Hi Dears,
I got a problem , How can I disable the parent row filed (ex :sum ,max,min),
when I using PivotTable ,Because That’s important issue in my project .
Thank you so much!
Hi,
This can’t be configured currently, but we have it in our plans.
In the current version of Pivot, you can use API and events of DataTable to access and change cell values. So it possible to set empty values for parent row.
if ($$("pivot").config.structure.rows.length > 1) {
this.data.each(
function (obj) {
if (obj.$count != 0) {
this.eachColumn(function (columnId) {
if (this.getColumnIndex(columnId)) {
obj[columnId] = "";
}
});
}
}
, this);
this.refresh();