...desription...
To create a Multilevel Pivot Report with the Report Designer, navigate to the Reports → Create a Report, and follow the steps below:
...
- 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.
...
Fill in these fields to configure your report in a way you want.
Row a column a row pivot Column a column a column pivot | Multilevel Pivot report. |
| Aggregation type | Select a type of the numeric data aggregation from one of these options: - Average;
- Count;
- Count distinct - counts the number of unique values of the column set in the Aggregation column;
- Sum.
|
| 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 |
|
| 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 |
|