Pivot Grid
PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data.
Allowed Parent Components:
Allowed Child Components:
Trigger On Aggregate Click
➤ Allow Column Resizing
Check this to allow users to resize grid columns.
Allowed Values: Yes/No
➤ Allow Column Sorting
Check this to allow users to sort column values. This will enable click on header cell which will sort the values in ascending or descending order.
Allowed Values: Yes/No
Check this to show borders to the Grid.
Allowed Values: Yes/No
➤ Hide Column Lines
Check this to show lines between the grid columns.
Allowed Values: Yes/No
Check this to add zebra-striping to the rows within the table
Allowed Values: Yes/No
➤ Show Single Level Child At Same Level
Enable this to show the parent and it's child(only if it is single) at the same level.
Allowed Values: Yes/No
Enable this to hide drill down in the columns.
Allowed Values: Yes/No
➤ Hide Configurator
Enable this to hide pivot configurator from the grid header
Allowed Values: Yes/No
➤ Max Freeze Rows Column Width
Enter a numeric value to control the maximum width of the frozen rows column.
Allowed Values: Any number value
➤ Group By Attribute
Group by clause will be performed on the selected attribute.
Allowed Values: Group by clause will be performed on the selected attribute.
➤ Show Group Before
Enable this to show the group summary first.
Allowed Values: Yes/No
➤ Empty Value Text
Add a value to display if pivot value is empty
Allowed Values: Free text field
➤ Aggregate Column Colors
specify custom colors to be applied on aggregate column values
Allowed Values: Free text field
➤ Row Column Colors
specify custom colors to be applied on row column values
Allowed Values: Free text field
➤ Summary Column Colors
specify custom colors to be applied on row summary column values
Allowed Values: Free text field
➤ Hide Row Summary
Enable this to hide row level summary values.
Allowed Values: Yes/No
Enable this to hide the footer i.e. Grand Total.
Allowed Values: Yes/No
Allowed Values: Any number value
Enter a numeric value to change the height of each row in the pivot grid. By default, height is 36
Allowed Values: Any number value
➤ Use Existing Data Source
Choose this prop if you want to reuse a Data Source that was defined on some other component on this page or any of the parent abstract pages.
Allowed Values: Yes/No
Select a datasource from the list.
Allowed Values: Select a datasource from the list.
➤ Data Source Alias
Allowed Values: Free text field
➤ Default Where Clause
Allowed Values: Free text field
Allowed Values: Any number value
➤ Order By Clause
e.g. #firstAttr#, #secondAttr# DESC
Allowed Values: Free text field
Check this property to query the selected datasource on component render.
Allowed Values: Yes/No
➤ Execute Count SQL
Check this to execute count SQL to get the total number of rows in the database on a query. You can get this value by using the expression: #{DataStore.totalLength}
Allowed Values: Yes/No
➤ Execute Distinct SQL
Check this to execute distinct SQL to get the total number of distinct rows in the database on a query.
Allowed Values: Yes/No
➤ On Aggregate Click
Allowed Values: Controller Function
Select a value to add margin on all four sides of the component. It is a shorthand for margin-top, margin-right, margin-bottom, and margin-left.
Allowed Values: Any number value
➤ Margin Bottom
Select a value to add margin on the bottom of the component.
Allowed Values: Any number value
Select a value to add margin on the left of the component.
Allowed Values: Any number value
Select a value to add margin on the right of the component.
Allowed Values: Any number value
Select a value to add margin on the top of the component.
Allowed Values: Any number value
Select a value to add padding on all four sides of the component. It is a shorthand for padding-top, padding-right, padding-bottom, and padding-left.
Allowed Values: Any number value
➤ Padding Bottom
Select a value to add padding in the bottom of the component.
Allowed Values: Any number value
Select a value to add padding in the left of the component.
Allowed Values: Any number value
➤ Padding Right
Select a value to add padding in right of the component.
Allowed Values: Any number value
Select a value to add padding in top of the component.
Allowed Values: Any number value
