sortable Boolean|Object
(default: false)
If set to true
the user could sort the widget by clicking the dimension fields. By default sorting is disabled.
Can be set to a JavaScript object which represents the sorting configuration.
Example - enable sorting
<div id="configurator"></div>
<script>
$("#configurator").kendoPivotConfigurator({
sortable: true,
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
rows: [{ name: "[Product].[Product]" }],
measures: ["[Measures].[Internet Sales Amount]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: {
url: "https://demos.telerik.com/olap/msmdpump.dll",
dataType: "text",
contentType: "text/xml",
type: "POST"
}
},
schema: {
type: "xmla"
}
}
});
</script>
sortable.allowUnsort Boolean
(default: false)
If set to true
the user can get the widget in unsorted state by clicking the sorted dimension field.
Example - allow unsorting
<div id="configurator"></div>
<script>
$("#configurator").kendoPivotConfigurator({
sortable: {
allowUnsort: true
},
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Geography].[City]" } ],
rows: [{ name: "[Product].[Product]" }],
measures: ["[Measures].[Internet Sales Amount]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: {
url: "https://demos.telerik.com/olap/msmdpump.dll",
dataType: "text",
contentType: "text/xml",
type: "POST"
}
},
schema: {
type: "xmla"
}
}
});
</script>