Pivot 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 for issues of comparasing, summarizing, and counting a large amount of data.
To create a Pivot Report with the Report Designer, navigate to the Reports → Create a Report, and follow the steps below:
Click Next or the tabs of the Report Designer to navigate. This navigation is only available after filling in the mandatory fields.
- On the Data tab, fill in the mandatory fields:
- Report name - enter the desired name;
- Table - select the table you need.
- On the Type tab, select Pivot report option and click Next.
- On the Configure tab, customize the Pivot report.
- Click Update to generate your report.
- Click Next to customize the report style.
- On the Style tab, configure the Pivot report style.
- Click Update to apply the style changes.
- Click Save.
Configure a Report
Fill in these fields to configure your report in a way you want.
| Field | Description |
|---|---|
| Row | Set a desired table column as a row for pivot report. |
| Column | Set a desired table column as a column for pivot report. |
| Aggregation type | Select a type of the numeric data aggregation from one of these options:
|
| Aggregation column | Select a table column with numeric values for data aggregation. |
| Groups limit | Set the limit of the data groups shown in your report with a particular number in this field. |
| Show rest as other | Set this checkbox on to show the data groups not included in Groups limit as one. |
Customize a Style
| General Style | |
|---|---|
| Report width | |
| Drilldown list layout | Select the list layout of the report data. |
