columnWidth Number

The width of the table columns. Value is treated as pixels.

This option defines the minimum width of the column. If the widget is wider then (column numbers * column width) then the columns will be wider then the defined value. This is done to occupy all available space in the widget wrapper.

Example - set the column width as a number

<div id="pivotgrid"></div>
    columnWidth: 200,
    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: "",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
        schema: {
            type: "xmla"
In this article