pivot grid extension

[Opan Mustopah]

hello again,

want to ask about pivot gird extension, btw its great plugin.

after seeing and try pivot grid demo, i see, value on pivot grid is only support for number value, but not string value,

is it possible to use string as value on pivot grid? because when i try to mov field that contain string value to 'value' panel, all value become 0 (zero)

thanks in adnvance

[stworthy]

You have to use numeric for value fields because they will be calculated.

[Opan Mustopah]

thanks stworthy for your answer.
but,

is there a way to using like formatter properties on datagrid, so i can do something like bind the value with another value contains string?
because i really need this plugin to support that feature.

thanks in advance

[stworthy]

The default operator on the value fields is 'sum'. You can try to extend other operators to fit your requirement. For more information please refer to http://www.jeasyui.com/extension/pivotgrid.php.

Code:

//implement the 'sum' operator
$.extend($.fn.pivotgrid.defaults.operators, {
	sum: function(rows, field){
		var opts = $(this).pivotgrid('options');
		var v = 0;
		$.map(rows,function(row){
			v += parseFloat(row[field])||0;
		});
		return v.toFixed(opts.valuePrecision);
	}
});

[Opan Mustopah]

thanks stworthy for your fast response,
i'll try it and i'll report it to you if its works or not.