Pivot ivot Tables Reports represent your data in a table view with aggregating, grouping, and analyzing using two metrics as row and column for your chart. This report type is extremely useful . The data is aggregated, grouped, and analyzed basing on two metrics.
Tip |
---|
This report view is useful for issues of comparing, summarizing, and counting a large amount of data. |

Create a pivot table report
Use Report Designer to create, configure, and style gauge pivot tables reports.
Panel |
---|
title | To create a bar report, follow the steps below: |
---|
|
- Navigate to the Reports → Create a ReportNew.
- On the the Data tab tab, fill in the mandatory fields:
- Report name - enter Name – enter the desired name;
- Table - select Table – select the table you want to use as a source.
- Click Next or the Type tab to continue.
- On the Type tab, select the Pivot report option and click Next.click the Pivot table icon:
Image Added - Click Next or the Configure tab.
Fill in the mandatory fields and configure the data, then click Refresh to generate a report. Note |
---|
The Report Designer can stop the report generating if there is a large amount of data to display. Use the Condition Builder to limit the data sampling or try another type of | Configure a report and click Refresh to generate a
- Customize a the style of the report created, and click Refresh.
- Click Save.
Info |
---|
To open the saved report, navigate to the to Reports → All reports menu and Reports and select one from the list. |
|
a
To configure a report, follow the steps below:
- On the Configure tab, specify the report dataset.
- Click Refresh to build the report.
- Click Save to save the report.
Info |
---|
Use the the Condition Builder to establish additional conditions for data filtering and grouping. - Click the icon
Image Modifiedto open the Condition Builder , establish your conditions, then click - .
- Set the filters.
- Click Refresh to apply changes.
 |
Anchor |
---|
| configure tab fields pivot report |
---|
| configure tab fields pivot report |
---|
|
Field | Mandatory | Description |
---|
RowColumn | Y | Set the desired table column as a |
row column for the pivot table report. |
ColumnRow | Y | Set the desired table column as a |
column row for the pivot table report. |
Aggregation |
typeThe data aggregation allows preparing the Type | N | Select the data aggregation to create combined datasets for data processing |
according to the user needs.Select a type of numeric data aggregation with one of these Average - counts - Average – counts an average number of the column values.
- Count
|
- counts the column values distinct - counts - Distinct – counts the number of unique values of the column.
- Sum
|
- counts - – counts the sum of the numeric data values in this table column.
Info |
---|
The Sum and Average settings make sense if the aggregation column keeps the numeric data. |
The aggregation option selected is applied to the table column set in |
the Aggregation column fieldthe Aggregation Column field. |
Aggregation |
columnColumn | N | Select a table column with numeric values for data aggregation. Info |
---|
The Aggregation Column is only available if the Aggregation Type option is Average, Count Distinct, Sum. |
|
Groups |
limitSet Define the limit of the data groups shown in your report |
with a particular number in this field rest otherSet on to show the data groups not included in Groups |
limitLimit as one. Info |
---|
The Show Rest as Other is only available if the Groups Limit option is specified. |
|
Use the the Condition Builder to establish additional conditions for your report data filtering and grouping.
Customize
a stylethe style Anchor |
---|
| customize the style pivot table |
---|
| customize the style pivot table |
---|
|
You can configure the report look and multilevel pivot table score colors in any way you want with the style settings.
To customize a report style, follow the steps below:
- On the Style tab of your report, configure the Drilldown list layout settingsettings.
- Click Refresh to apply the changes.
- Click Save to save the report.
Add title and customize the data list and table views with the settings below.
The Style tab fields
General |
---|
Field | Mandatory | Description |
---|
Drilldown List Layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon Image Added to select the desired list view of the source table.
|
Decimal Precision | N | Define how many numbers should be displayed after the point of numeric data values in your chart. Info |
---|
This field appears when the Aggregation Type field in the Configure tab contains Sum or Average. |
|
Title |
---|
Field | Mandatory | Description |
---|
Report Title Show Type | N | Select the type for the report title showing. Available options: |
Report Title | N | Specify the title of the report you create. |
Report Title Size | N | Specify the number of pixels to set the size of the report title. |
Report Title Color | N | Select the color of the report title. Click the magnifier icon Image Added to select one of the available colors. |
Title Alignment | N | Select the alignment of the report title. Available options: - Left Top
- Left Bottom
- Right Top
- Right Bottom
- Center Top
- Center Bottom.
|
Bold Title | N | Select this checkbox to make the chart title bold. |