Hello Valentin,

You can apply formatting on rendering stage, as in the igGrid. Actually the igPivotGrid uses igGrid internally. Try handling igGrid.rowsRendering event where you should set igGrid.column.formatter callback and in there call the $.ig.formatter function like this:

$("#pivotGrid").on("iggridrowsrendering", function (evt, ui) {

for (var i = 0; i < ui.owner.options.columns.length; i++) {

ui.owner.options.columns[i].formatter = function (val, rec) {

return $.ig.formatter(parseFloat(val), "number", "numeric");

};

}

});

I'm also attaching a sample for your reference.

Hope this helps,
Martin Pavlov
Infragistics, Inc.

I just used this technique to format numbers however I encountered an issue: What if I want to activate sorting on these values?

Since the formatted values are string, the sorting function uses a lexical order which is incorrect for numbers...

Is there a formatter function for PivotGrid like the one for Grid? Or a way to set a custom sorting logic?

Thanks, using the custom aggregator worked