If the store type you use is not XmlaStore, you need to describe data from the data source for PivotGrid by assigning a list of fields to this option. Each pivot grid field must be associated with the field in the store using the dataField option.

Fields can be instantly placed into the pivot grid by assigning a value to the area option. If this option is undefined, the field will be displayed in the Field Chooser only.

NOTE

If this array is not specified and the retrieveFields option is set to true, the fields will be generated automatically and placed to the Field Chooser.

filter

Specifies data filtering conditions. Cannot be used for the XmlaStore store type.

remoteOperations

Note that you cannot use the selector option along with remote operations, because the selector function is ignored on the server side. Instead of using selector, create a calculated data field on your web server, and then bind the pivot grid field directly to it.