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 | ||
---|---|---|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
Configure a Report
Fill in these fields to configure your report in a way you want.
...
|
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.
|
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. |
...
Set the horizontal alignment of the chart title with one of the options:
- Left;
- Center;
- Right.
...
Set the vertical alignment of the chart title with one of the options:
- Top;
- Middle;
- Bottom.
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 | ||||||||
---|---|---|---|---|---|---|---|---|
|