如何为Web应用透视网格的列轴添加维度？这一招很简单

Kendo UI for jQuery R2 2021试用版下载

Kendo UI是带有jQuery、Angular、React和Vue库的JavaScript UI组件的最终集合，无论选择哪种JavaScript框架，都可以快速构建高性能响应式Web应用程序。通过可自定义的UI组件，Kendo UI可以创建数据丰富的桌面、平板和移动Web应用程序。通过响应式的布局、强大的数据绑定、跨浏览器兼容性和即时使用的主题，Kendo UI将开发时间加快了50%。

下面的示例演示如何使用Kendo UI PivotGrid API向小部件的列轴添加新维度。

 

<div id="example">
<button id="add">Add "ProductName"</button>
<div id="pivotgrid"></div>

<script>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
dataSource: {
data: products,
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number" },
UnitsInStock: { type: "number" },
Discontinued: { type: "boolean" },
CategoryName: { field: "Category.CategoryName" }
}
},
cube: {
dimensions: {
ProductName: { caption: "All Products" },
CategoryName: { caption: "All Categories" },
Discontinued: { caption: "Discontinued" }
},
measures: {
"Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" }
}
}
},
columns: [{ name: "CategoryName", expand: true }],
rows: [{ name: "Discontinued", expand: true }],
measures: ["Sum"]
}
}).data("kendoPivotGrid");

$("#add").click(function() {
var ds = pivotgrid.dataSource;
var columns = ds.columns();

columns.push("ProductName");

ds.columns(columns);
});
});
</script>
</div>

 

---

了解最新Kendo UI最新资讯，请关注Telerik中文网！