Integrated Field Chooser
Documentation
The field chooser is a pivot grid element that allows you to manage the displayed fields. You can invoke it by clicking the Field Chooser icon at the top-left corner or by selecting the "Show Field Chooser" command on the PivotGrid's context menu. Changes made in the field chooser can be applied to the PivotGrid in instant or on-demand mode. In the latter case, the field chooser is supplied with the OK and Cancel buttons.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
var DemoApp = angular.module('DemoApp', ['dx']);
DemoApp.controller('DemoController', function DemoController($scope) {
var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({
fields: [
{ dataField: "[Product].[Category]", area: "row" },
{
dataField: "[Product].[Subcategory]",
area: "row",
headerFilter: {
allowSearch: true
}
},
{ dataField: "[Ship Date].[Calendar Year]", area: "column" },
{ dataField: "[Ship Date].[Month of Year]", area: "column" },
{ dataField: "[Measures].[Customer Count]", area: "data" }
],
store: {
type: "xmla",
url: "https://demos.devexpress.com/Services/OLAP/msmdpump.dll",
catalog: "Adventure Works DW Standard Edition",
cube: "Adventure Works"
}
});
$scope.applyChangesMode = "instantly";
$scope.pivotGridOptions = {
allowSortingBySummary: true,
allowSorting: true,
allowFiltering: true,
showBorders: true,
dataSource: pivotGridDataSource,
height: 470,
fieldChooser: {
enabled: true,
allowSearch: true
},
bindingOptions: {
"fieldChooser.applyChangesMode": "applyChangesMode"
}
};
$scope.applyChangesModeOptions = {
items: ["instantly", "onDemand"],
width: 180,
value: "instantly",
onValueChanged: function(data) {
$scope.applyChangesMode = data.value;
}
};
});
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.5/css/dx.light.css" />
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js"></script>
<script>window.angular || document.write(decodeURIComponent('%3Cscript src="js/angular.min.js"%3E%3C\/script%3E'))</script>
<script src="https://cdn3.devexpress.com/jslib/19.1.5/js/dx.all.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="index.js"></script>
</head>
<body class="dx-viewport">
<div class="demo-container" ng-app="DemoApp" ng-controller="DemoController">
<div id="pivotgrid">
<div dx-pivot-grid="pivotGridOptions"></div>
<div class="options">
<div class="caption">Options</div>
<div class="option">
<span>Apply Changes Mode:</span>
<div id="applyChangesMode" dx-select-box="applyChangesModeOptions"></div>
</div>
</div>
</div>
</div>
</body>
</html>
.options {
padding: 20px;
background-color: rgba(191, 191, 191, 0.15);
margin-top: 20px;
}
.caption {
font-size: 18px;
font-weight: 500;
}
.option {
margin-top: 10px;
}
#applyChangesMode {
margin-top: 5px;
}