Set of tools
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 not to show all values, but to filter them. Our component provides 3 ways to do that:
- Filter by members’ names allows choosing which exact members will be shown for some field. Search tool helps to find the necessary members quickly.
- Filter by value returns top X results.
- Report filter is used for the convenient representation of data in reports. This filter helps to focus on data subsets and is not overloaded with large amounts of data.
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. Data can be sorted in ascending and descending order of a certain row or column. Try that function to sort the table based on some value, for example, from the highest price to the lowest.
If rows contain more than one field, one of them 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 convenient for looking at your data from a different point of view.
After configuring the table, there is no need to memorize all the details in order 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 report. It will show table at exactly the same state.
Also you can print table directly from the component. All kinds of views are easily printed and can be shown, for example, at the meeting with colleagues. Export in HTML, CSV, Excel, PDF, PNG formats is built-in and helps to get results of your work.
Conditional formatting allows highlighting cells depending on their values. Formatting means changing font size, font color, background color of the cell in order to distinguish it from others. Conditional formatting is a useful tool that makes information noticeable. This function can be successfully used to simplify the process of analyzing the data.
Number formatting is convenient for changing appearance of numbers, without actual changing of value. You can add currency symbol or decimal separator.
Configuration of fields
Fields list allows choosing only values you want to work with. Each field can be added as row or column or can be selected as a value for the pivot table. This tool helps to 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.
New calculated value
If value list doesn’t contain desired numbers, you can add your own calculated value. Here you can compose a new item from existing values, arithmetic operators, and logical expressions. For example, this can be used 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, grand totals and subtotals can be easily hidden by just one click.
Each number in the pivot table represents one or more records from data. Click twice to drill through the cell to data from which it was composed. A pop-up with the list of records from which the cell value is composed will be opened. The list of fields is available for this pop-up to manage them in run time.
The component supports 3 forms of tables:
- Compact pivot table combines fields selected for rows into one column so the grid looks more compressed.
- Classic pivot table places each field selected for rows in a separate column and puts subtotals as a separate row on the bottom.
- Flat table places all fields as columns and shows the data in rows fact by fact.
See your data in a visual form using our charts. The component offers all common types:
- Horizontal Bar
- Bar Line
- Bar Stack
Charts are interactive: by clicking on X axis and legend you can expand the data and see new values on the chart. Drill through function is also available on charts – just double click on the chart element – bar on the bar chart or segment on the pie chart.