The new pivot style report tool is an easily configurable, presentation-quality business report tool used for visualising relational data sources in cross-tabular format. It includes drill-up and drill-down capabilities and allows Users to easily aggregate data. Sorting, filtering, and grouping data is also supported.
This is a powerful control for organising and summarising your business data and displaying the results in a table and chart format. It includes major features such as built-in aggregations, a configurable field list for report manipulation, Excel-style filtering and sorting, and Excel exporting.
The component provides a built-in Field List similar to Microsoft Excel, which allows you to add or remove fields and rearrange the fields between different axes, including column, row, value, and filter, along with filter and sort options dynamically at runtime.
The field list icon is displayed in the top right corner of the pivot table.
| Setting | Description |
|---|---|
| Add or remove fields | Check or uncheck the box besides each field to add or remove fields from the report |
| Re-arrange fields | Use the drag-and-drop holder to drag any field, and drop it into the column, row, value, or filter axis to alter the report |
| Sort data | Use the sort icon besides each field (in row and column axes) to sort data in ascending or descending order |
| Filter data | Use the filter icon besides each field (in row, column and filter axes) to include or exclude data |
| Change cell value type | Use the drop-down in the top left corner to summarise values displayed by sum, count, min, max, avg, etc |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article