![selection mode data toolbar selection mode data toolbar](https://slideplayer.com/slide/12858822/78/images/17/Important+Toolbar+Buttons.jpg)
Pivot Mode On: When pivot mode is on, selecting a column will trigger the column to be either aggregated, grouped or pivoted depending on what is allowed for that column.If you drag a column from the tool panel onto the grid it will make it visible. A selected column is visible and an unselected column is hidden. Pivot Mode Off: When pivot mode is off, selecting a column toggles the visibility of the column.Selecting columns means different things depending on whether the grid is in pivot mode or not as follows: Remember to mark the column definitions with enableRowGroup for grouping, enablePivotįor pivoting and enableValue for aggregation, otherwise you won't be able to drag and drop theĬolumns to the desired sections. You will now have a pivot grid showing total gold medals for each country (rows showing countries) by year (columns showing years). Reset (refresh) the demo and do the following: Drag and Drop a column inside the columns sections to reorder columns in the grid.Checking / unchecking columns will show / hide the columns.For example, it does not make sense to aggregate the country column, but it does make sense to group rows by country. Although each column can be dragged to these sections, it does not make sense to do so. This means all columns can be dragged to any of the Row Groups, Values and Column sections.
![selection mode data toolbar selection mode data toolbar](https://4.bp.blogspot.com/-SmqP3OFOEgQ/T32yVk4yTCI/AAAAAAAAEC8/ojMXcihc05w/s320/564161_3321275764756_1654190085_2639912_1985571085_n.jpg)
Grid property defaultColDef has enableValue, enableRowGroup and enablePivot set.Grid property toolPanel='columns' which shows only the columns tool panel.
![selection mode data toolbar selection mode data toolbar](https://www.megasoftware.net/web_help_10/prototype-options.png)
Simple Exampleīelow shows a simple example of the columns tool panel. The columns tool panel provides functions for managing the grid's columns.