var DemoApp = angular.module('DemoApp', ['dx']);
DemoApp.controller('DemoController', function DemoController($scope) {
$scope.pivotGridOptions = {
allowSorting: true,
allowSortingBySummary: true,
allowFiltering: true,
height: 620,
showBorders: true,
rowHeaderLayout: "tree",
scrolling: {
mode: "virtual"
},
dataSource: {
remoteOperations: true,
store: DevExpress.data.AspNet.createStore({
key: "OrderID",
loadUrl: "https://js.devexpress.com/Demos/WidgetsGalleryDataService/api/Sales/Orders"
}),
fields: [{
caption: "Category",
dataField: "ProductCategoryName",
width: 250,
expanded: true,
sortBySummaryField: "SalesAmount",
sortBySummaryPath: [],
sortOrder: "desc",
area: "row"
}, {
caption: "Subcategory",
dataField: "ProductSubcategoryName",
width: 250,
sortBySummaryField: "SalesAmount",
sortBySummaryPath: [],
sortOrder: "desc",
area: "row"
}, {
caption: "Product",
dataField: "ProductName",
area: "row",
sortBySummaryField: "SalesAmount",
sortBySummaryPath: [],
sortOrder: "desc",
width: 250
}, {
caption: "Date",
dataField: "DateKey",
dataType: "date",
area: "column"
}, {
caption: "Amount",
dataField: "SalesAmount",
summaryType: "sum",
format: "currency",
area: "data"
}, {
caption: "Store",
dataField: "StoreName"
}, {
caption: "Quantity",
dataField: "SalesQuantity",
summaryType: "sum"
}, {
caption: "Unit Price",
dataField: "UnitPrice",
format: "currency",
summaryType: "sum"
}, {
dataField: "Id",
visible: false
}]
}
};
});
<!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.5.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/20.2.6/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.6/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/20.2.6/js/dx.all.js"></script>
<script src="https://unpkg.com/devextreme-aspnet-data@2.7.1/js/dx.aspnet.data.js"></script>
<script src="index.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body class="dx-viewport">
<div class="demo-container" ng-app="DemoApp" ng-controller="DemoController">
<div dx-pivot-grid="pivotGridOptions">
</div>
</body>
</html>