How to choose fields to show
This guide explains how to configure which fields are shown on the grid. You can adjust them either through the field list in the UI or through the code.
In the code, displayed fields are defined in the SliceObject inside the state.
Default configuration
If no fields are defined in the SliceObject on initialization, Flexmonster applies a default configuration:
-
Flat table—all available fields are displayed on the grid.
-
Pivot table—the grid is empty until you select fields manually.
Adding fields to the grid
In this section, learn how to add fields to the pivot and flat tables.
In the pivot table
Note You must specify at least one value; otherwise, the grid will be displayed without values.
In the flat table
Rearranging fields
In this section, learn how to rearrange currently presented fields using the field list in the pivot and flat tables.
In the pivot table
Step 1. Open the field list if necessary.
Step 2. Сhange the order of fields within the Rows, Columns, or Values areas by dragging them up or down.
Step 3. Select Apply in the field list.
In the flat table
Step 1. Open the field list if necessary.
Step 2. Drag a field to change its order.
Step 3. Select Apply in the field list.
Removing fields
In this section, learn how to remove fields from the pivot and flat tables.
In the pivot table
In the flat table
Changing the aggregation for a field
Each field can be assigned an aggregation function that defines how its values are summarized. See the list of available aggregations and how to configure them.
Managing totals of a field in the flat table
In the flat table, you can configure the visibility of a total cell for each field separately.
Note By default, totals are hidden in the flat view. Learn how to show totals on the grid.