Pivot Table Component offers a significant number of tools to handle the data. End users can use them to ease the process of analyzing data.
Sometimes it’s more convenient to filter the data instead of showing all values. Our component provides three ways to do that:
For a better understanding, it is convenient to sort data. You can place rows or columns in alphabetical order by their names.
Another kind of sorting is based on numbers. You can sort data in ascending and descending order of a specific row or column. Try this feature to sort the table based on some value (e.g., from the highest price to the lowest).
If rows contain more than one field, one of the fields is nested inside the other. Inner field values can be expanded by clicking on the outer field name. This way, you can see additional information if necessary. Another click will collapse inner field values.
To change nesting order, you can just drag & drop fields on the grid.
Some fields have more than one level. You can drill up and down on the levels of such hierarchies. This tool is especially useful for looking at your data from a different point of view.
After configuring the table, there is no need to memorize all the details to repeat them next time. It’s possible to save the report with all the configurations you’ve made. The next time using the component, you can open the saved report that will show the table in the same state.
Also, you can print the table directly from the component. All kinds of views are easily printed and can be shown, for example, at a meeting with colleagues. Export in HTML, CSV, Excel, PDF, PNG formats is built-in and helps get your work results.
Conditional formatting allows highlighting cells based on specified criteria, thus making the information noticeable. Using conditional formatting, you can change font size, font color, and background color of the cell to distinguish it from others. This feature simplifies the process of analyzing the data.
Number formatting is used for changing the appearance of numbers without the actual changing of value. You can add a currency symbol, a decimal separator, and many more.
The Field List allows choosing only the values you want to work with. Each field can be added as a row or column or selected as a value for the pivot table. This tool helps organize data the way you want: by experimenting with fields, it’s easy to achieve the most convenient view. Moreover, aggregation functions are applied to the values in the table. Use sum, count, average, or one of the others to make data look eloquent.
If the value list doesn’t contain the desired numbers, you can add your calculated value. Here you can compose a new item from existing values, arithmetic operators, and logical expressions. For example, you can use this for combining some values or comparing them.
Another useful tool is grand totals and subtotals. No need to count results yourself – the component will do that automatically. It helps to make conclusions based on some values. However, you can easily hide grand totals and subtotals with just one click.
Each number in the pivot table represents one or more records from data. Double click to drill through the cell to non-aggregated data, and you will see a pop-up window with details about the cell. The list of fields is available for this pop-up to manage them in run time.
The component supports three forms of tables:
See your data in a visual form using our charts. The component offers all common types:
Charts are interactive: by clicking on the X-axis and the legend you can expand the data and see new values on the chart. The drill-through feature is also available on charts – just double click on the chart element (e.g., bar on the bar chart or segment on the pie chart).