The Pivot Grid (TPivotGrid)

The pivot grid is the component used to display the data source's data using the layouts defined in the underlying TPivotMap, using the Map property.  You can control most of the appearance of items on the grid using the Settings property.

 

The MapBuilder is used to organize the dimensions of the PivotCube quickly.  Here, you can drag and drop dimension items between the map's rows and columns.  You can set items to unused and disabled states. The advantage of using a MapBuilder is that you can quickly view all the available dimension items and their states, especially if you have a lot of items.  In these situations, the dimension toolbar would have many items and you would need to repeatedly scroll the toolbar to select them. You can also activate the dimension editor for the individual dimensions by clicking on the button on the lower left corner.

 

Activate global measure manager

The measure manager is used to set the attributes of each measure item easily.  Among the attributes you can set are the visibility of each measure, the displayed measure value and the filtered values.  Please see the visual guide on Measure Manager for more details.

This will expand the next level of all items for this dimension.  In this example, the Country and Cities dimension will be expanded for each Store.  Once a dimension is expanded, the image will change to a collapsed state ().  Clicking on the button now will collapse the level.  If any of the dimension items are expanded to the next level, this button will also display a collapsed state.

This will expand the next level only for the selected row.  In this example, the Country and Cities dimension will be expanded only for the DHL store.  Clicking on the button again will collapse the Country and Cities dimension.

This will expand the next level of all items for this dimension.  In this example, the Year dimension will be expanded for each Client.  Once a dimension is expanded, the image will change to a collapsed state ().  Clicking on the button now will collapse the level.  If any of the dimension items are expanded to the next level, this button will also display a collapsed state.

This will expand the next level only for the selected column.  In this example, the Year dimension will be expanded only for the Action Club client.  Clicking on the button again will collapse the Year dimension.

This will display a multiple bar chart for the selected dimension item.  Each measure's view values will be used to generate the chart.  If you select any of the dimension's values from the treeview on the left, the chart will be redrawn to display only the values for the selected item.

This will display a multiple bar chart for the selected dimension item and view.  If you select any of the dimension's values from the treeview on the left, the chart will be redrawn to display only the values for the selected item.

In TPivotGrid, you can sort on a dimension's values or on a measure's view values.  To sort a dimension's values, click on the dimension's header area.  In the example, this means clicking anywhere on the Client or Store 'boxes'.  To sort a measure's view, simply click anywhere on the view's caption. 

When an item is sorted, a sort indicator will appear in the item's caption area.  Clicking on the area again will toggle the sort between the ascending and descending order.  To cancel the sort, right-click on the caption area.

When a view is sorted, the columns in the view will be highlighted.  The style used is determined by the TPivotgrid.Settings.Cells.Sort property.