Checkbox
A Pivot Grid (also called a Pivot Table) is a powerful data summarization and analysis tool. It enables users to dynamically group, filter, and aggregate data across multiple dimensions, producing cross-tabular reports without altering the underlying dataset.
The Pivot Grid provides flexibility in analyzing large datasets and uncovering patterns or trends by simply rearranging fields into rows, columns, and measures.
Best Situations to Use Pivot Grid
Use a Pivot Grid when you need to:
Analyze multi-dimensional data without creating multiple static reports.
Perform ad-hoc analysis on dynamic datasets.
Generate cross-tabular reports for comparison across different dimensions.
Allow business users to explore data without writing SQL queries.
Example use cases:
Comparing sales by region, product, and time.
Evaluating customer engagement metrics across multiple channels.
Summarizing financial data by department and quarter.
Properties of the Pivot Grid
The Pivot Grid component has the following configurable properties:
General
Component Name
Assign a unique identifier to the chart component.
Left
Defines the horizontal position of the grid on the page.
Top
Defines the vertical placement of the grid within the display area.
Height
Sets the vertical dimension of the grid.
Width
Sets the horizontal dimension of the grid.
Initial Visibility
Determines whether the grid is visible by default when previewed.
Max Button
Enables or disables the option to maximize the grid.
First Column Width
Sets the width of the first column for better readability.
Fit Columns
Automatically adjusts columns to the best fit based on content.
Background
Gradient Rotation
Adjusts the angle of the gradient fill.
Opacity
Sets the transparency level of the background.
Notes
The Pivot Grid does not modify the underlying database or spreadsheet. It only transforms the way data is displayed.
Proper use of filters and aggregation ensures faster insights and better performance.