...desription...
To create a Multilevel 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 Multilevel Pivot report option and click Next.
- On the Configure tab, customize the Multilevel Pivot report.
- Click Update to generate your report.
- Click Next to customize the report style.
- On the Style tab, configure the Multilevel 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 |
---|---|
Rows | Set desired table columns as rows for Multilevel Pivot report. |
Columns | Set desired table columns as columns for Multilevel 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 | |
Low score color | |
Decimal precision | |
Title Style | |
Report title show type | |
Report title | |
Report title size | |
Report title color | |
Title horizontal alignment | |
Title vertical alignment |