Multi-Level Headers (Bands)
Our DataGrid widget allows you to group multiple columns under one header (band). This demo shows an example: the "Nominal GDP" and "Population" bands have banded columns.
You can drag one of the bands across the grid to reorder all its banded columns simultaneously. You can also move the band to the column chooser and hide the banded columns. Banded columns remain interactive.
To create the banded layout, do one of the following:
-
Assign a hierarchical structure to the columns option. The code in this demo is an example.
-
Implement a customizeColumns function where you should specify the ownerBand and isBand column options. Refer to the isBand description for a code sample.
www.wikipedia.org
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
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.
<template>
<DxDataGrid
id="grid"
:data-source="countries"
:column-auto-width="true"
:allow-column-reordering="true"
:show-borders="true"
>
<DxColumnChooser :enabled="true"/>
<DxColumn data-field="Country"/>
<DxColumn
data-field="Area"
header-cell-template="headerTemplate"
/>
<DxColumn caption="Population">
<DxColumn
caption="Total"
data-field="Population_Total"
format="fixedPoint"
/>
<DxColumn
caption="Urban"
data-field="Population_Urban"
format="percent"
/>
</DxColumn>
<DxColumn caption="Nominal GDP">
<DxColumn
caption="Total, mln $"
data-field="GDP_Total"
format="fixedPoint"
sort-order="desc"
/>
<DxColumn caption="By Sector">
<DxColumn
:width="95"
:format="gdpFormat"
caption="Agriculture"
data-field="GDP_Agriculture"
/>
<DxColumn
:width="80"
:format="gdpFormat"
caption="Industry"
data-field="GDP_Industry"
/>
<DxColumn
:width="85"
:format="gdpFormat"
caption="Services"
data-field="GDP_Services"
/>
</DxColumn>
</DxColumn>
<template #headerTemplate="{ data }">
<div>Area, km<sup>2</sup></div>
</template>
</DxDataGrid>
</template>
<script>
import DxDataGrid, { DxColumn, DxColumnChooser } from 'devextreme-vue/data-grid';
import { countries } from './data.js';
export default {
components: {
DxDataGrid,
DxColumn,
DxColumnChooser
},
data() {
return {
countries: countries,
gdpFormat: {
type: 'percent',
precision: 1
}
};
}
};
</script>
<style>
#grid sup {
font-size: 0.8em;
vertical-align: super;
line-height: 0;
}
.long-title {
position: absolute;
top: -5px;
left: 0;
right: 45px;
z-index: 1;
}
.long-title h3 {
font-family: 'Segoe UI Light', 'Helvetica Neue Light', 'Segoe UI', 'Helvetica Neue', 'Trebuchet MS', Verdana;
font-weight: 200;
font-size: 28px;
text-align: center;
margin: 0 0 0 45px;
}
</style>
import { createApp } from 'vue';
import App from './App.vue';
createApp(App).mount('#app');
<!DOCTYPE html>
<html>
<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" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.3/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.3/css/dx.light.css" />
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import('./index.js');
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div class="long-title">
<h3>Country Area, Population, and GDP Structure</h3>
</div>
<div id="app"></div>
</div>
</body>
</html>
export const countries = [{
'ID': 1,
'Country': 'Brazil',
'Area': 8515767,
'Population_Urban': 0.85,
'Population_Rural': 0.15,
'Population_Total': 205809000,
'GDP_Agriculture': 0.054,
'GDP_Industry': 0.274,
'GDP_Services': 0.672,
'GDP_Total': 2353025
}, {
'ID': 2,
'Country': 'China',
'Area': 9388211,
'Population_Urban': 0.54,
'Population_Rural': 0.46,
'Population_Total': 1375530000,
'GDP_Agriculture': 0.091,
'GDP_Industry': 0.426,
'GDP_Services': 0.483,
'GDP_Total': 10380380
}, {
'ID': 3,
'Country': 'France',
'Area': 675417,
'Population_Urban': 0.79,
'Population_Rural': 0.21,
'Population_Total': 64529000,
'GDP_Agriculture': 0.019,
'GDP_Industry': 0.183,
'GDP_Services': 0.798,
'GDP_Total': 2846889
}, {
'ID': 4,
'Country': 'Germany',
'Area': 357021,
'Population_Urban': 0.75,
'Population_Rural': 0.25,
'Population_Total': 81459000,
'GDP_Agriculture': 0.008,
'GDP_Industry': 0.281,
'GDP_Services': 0.711,
'GDP_Total': 3859547
}, {
'ID': 5,
'Country': 'India',
'Area': 3287590,
'Population_Urban': 0.32,
'Population_Rural': 0.68,
'Population_Total': 1286260000,
'GDP_Agriculture': 0.174,
'GDP_Industry': 0.258,
'GDP_Services': 0.569,
'GDP_Total': 2047811
}, {
'ID': 6,
'Country': 'Italy',
'Area': 301230,
'Population_Urban': 0.69,
'Population_Rural': 0.31,
'Population_Total': 60676361,
'GDP_Agriculture': 0.02,
'GDP_Industry': 0.242,
'GDP_Services': 0.738,
'GDP_Total': 2147952
}, {
'ID': 7,
'Country': 'Japan',
'Area': 377835,
'Population_Urban': 0.93,
'Population_Rural': 0.07,
'Population_Total': 126920000,
'GDP_Agriculture': 0.012,
'GDP_Industry': 0.275,
'GDP_Services': 0.714,
'GDP_Total': 4616335
}, {
'ID': 8,
'Country': 'Russia',
'Area': 17098242,
'Population_Urban': 0.74,
'Population_Rural': 0.26,
'Population_Total': 146544710,
'GDP_Agriculture': 0.039,
'GDP_Industry': 0.36,
'GDP_Services': 0.601,
'GDP_Total': 1857461
}, {
'ID': 9,
'Country': 'United States',
'Area': 9147420,
'Population_Urban': 0.81,
'Population_Rural': 0.19,
'Population_Total': 323097000,
'GDP_Agriculture': 0.0112,
'GDP_Industry': 0.191,
'GDP_Services': 0.797,
'GDP_Total': 17418925
}, {
'ID': 10,
'Country': 'United Kingdom',
'Area': 244820,
'Population_Urban': 0.82,
'Population_Rural': 0.18,
'Population_Total': 65097000,
'GDP_Agriculture': 0.007,
'GDP_Industry': 0.21,
'GDP_Services': 0.783,
'GDP_Total': 2945146
}];
System.config({
transpiler: 'plugin-babel',
meta: {
'*.vue': {
loader: 'vue-loader'
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'vue': 'npm:vue@3.0.0/dist/vue.esm-browser.js',
'vue-loader': 'npm:dx-systemjs-vue-browser@1.0.15/index.js',
'mitt': 'npm:mitt/dist/mitt.umd.js',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.25.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@20.2.3',
'devextreme-vue': 'npm:devextreme-vue@20.2.3',
'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@0.9.5/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.0.0/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@2.0.0/dist/dx-gantt.js',
'preact': 'npm:preact@10.5.5/dist/preact.js',
'preact/hooks': 'npm:preact@10.5.5/hooks/dist/hooks.js',
'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js',
'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js'
},
packages: {
'devextreme-vue': {
main: 'index.js'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true
}
});