PivotGrid

Extension » PivotGrid

Usage Example

Create the pivot grid

Properties

The properties extend from treegrid, below is the added properties for pivotgrid.

Name Type Description Default
forzenColumnTitle string The title for the frozen column.
valueFieldWidth number The column width of the value fields. 80
valuePrecision number The precision of the value fields. 0
valueStyler function The cell styler function for the value fields.
valueFormatter function The cell formatter function for the value fields.
pivot object The pivot grid configuration, contains the following properties:
rows: array, the rows displayed on the left.
columns: array, the columns displayed above the grid.
values: array, the value fields displayed under the columns.
filters: array, the filters.
filterRules: object, the filter rules.
i18n object The i18n configuration, contains the following items:
fields: the title of the fields region.
filters: the title of the filters region.
rows: the title of the rows region.
columns: the title of the columns region.
ok: the title of the OK button.
cancel: the title of the CANCEL button.
operators object The operators on the value fields, available options are:'sum','count','max','min'.

Code example:

//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);
	}
});

Events

The events below extend from treegrid.

Methods

The methods below extend from treegrid.

Name Parameter Description
options none Return the options object.
getData none Get the loaded data.
layout none Open the layout dialog that allows the user to change the cube at runtime.

Download the EasyUI Extension:

jquery-easyui-pivotgrid.zip