Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

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.

Filtration

Sometimes it’s more convenient to filter the data instead of showing all values. Our component provides three ways to do that:

  • Filter on members allows choosing which exact members to show for a field. The search tool helps to find the necessary members quickly.
  • Filter on values returns top X results.
  • Report filter is used for the convenient representation of data in a report. This filter helps to focus on a specific data subset.

Sorting

sorting

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).


Grouping

expand

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.


Export options

export

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

Conditional formatting

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

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.


Configuration of fields

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.


New calculated value

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.


Totals

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.


Details

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.


Tables

layout

The component supports three forms of tables:

  1. Compact pivot table combines fields selected for rows into one column, so the grid looks more compressed.
  2. Classic pivot table places each field set for rows in a separate column and puts subtotals as a separate row on the bottom.
  3. Flat table places all fields as columns and shows the data in rows fact by fact.

Charts

See your data in a visual form using our charts. The component offers all common types:

  • Column
  • Bar
  • Line
  • Scatter
  • Pie
  • Column line
  • Stacked column

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).

allCharts