If the store type you use is not XmlaStore, you need to describe data from the data source for dxPivotGrid 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.