Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Pivot Tables Reports represent your data in a table view. The data is aggregated, grouped, and analyzed basing on more than two metrics (as columns and cells for your chart).
Tip |
---|
This report view is useful for issues of comparing, summarizing, and counting a large amount of data. |
Image Added
Create a multilevel pivot table report
Use Report Designer to create, configure, and style multilevel pivot tables reports.
Panel | ||
---|---|---|
| ||
|
Set Data
...
|
...
|
...
The further report customization is only available after defing the Report name and the Table.
Click the Next button or the Type tab to continue the Report creation.
Configure a Report
...
Select a table column as a criteria for data grouping.
...
|
Configure the data Anchor configure the data multilevel pivot configure the data multilevel pivot
configure the data multilevel pivot | |
configure the data multilevel pivot |
On the Configure tab, use settings to specify the maximum and minimum scale values of your multilevel pivot table report.
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 Condition Builder to establish additional conditions for data filtering and grouping.
|
The Configure tab fields
Field | Mandatory | Description |
---|---|---|
Columns | Y | Define desired table columns as data source for the Multilevel Pivot table report columns. |
Rows | Y | Define desired table columns as data source for the Multilevel Pivot table report rows. |
Aggregation Type | N | Select the data aggregation to create combined datasets for data processing. Available options:
|
Select a type of the numeric data aggregation from one of these options:
...
|
...
The aggregation option selected is applied to the table column set in the Aggregation Column field. | ||
Aggregation Column | N |
...
Select a table column with numeric values for data aggregation.
| |||
Groups |
...
Limit | N |
...
Define the limit of the data groups shown in your report with a particular number in this field. |
Show |
...
Rest as |
...
Other | N |
...
Select this checkbox |
...
to show the data groups not included in Groups |
...
Limit as one. |
...
Select the type for data slice from one of the options:
- Grouped - ;
- Stacked - .
...
|
Customize the style Anchor customize the style multilevel pivot customize the style multilevel pivot
customize the style multilevel pivot | |
customize the style multilevel pivot |
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 settings.
- 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
| ||
Decimal Precision | N | Set the number defining how much numbers should be displayed after the point of numeric data values in your chart. | ||
Title | ||||
Field | Mandatory | Description | ||
Report Title Show Type | N | Set 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 | ||
Title Alignment | N | Select the alignment of the report title. Available options:
| ||
Bold Title | N | Select this checkbox to make the chart title bold. |
Table of Contents | ||||||||
---|---|---|---|---|---|---|---|---|
|
...