Pivot Tables Reports represent your data in a table view with aggregating, grouping and analyzing using . The data is aggregated, grouped, and analyzed basing on more than two metrics (as columns and cells for your chart).
type is extremely useful view is useful for issues of |
comparasingcomparing, summarizing, and counting a large amount of data. |
Image AddedTo create a Multilevel Pivot Report with the Report Designer, navigate to the Reports → Create a Report, and
Create a multilevel pivot table report
Use Report Designer to create, configure, and style multilevel pivot tables reports.
Panel |
---|
title | To create a bar report, follow the steps below: |
---|
|
Info |
---|
Click Next or the tabs of the Report Designer to navigate. This navigation is only available after filling in the mandatory fields- Navigate to the Reports → Create New.
- On
|
the tab- tab, fill in the mandatory fields:
|
Report name - - Name – enter the desired name
|
;Table - select needOn - Click Next or the Type tab
|
, select Multilevel Pivot report option and click Next.- to continue.
- On the Type tab, click the Multilevel Pivot table:
Image Added - Click Next or the Configure tab.
Fill in the mandatory fields and configure the data, then click Refresh to generate a report. Note |
---|
The Report Designer can stop the report generating if there is a large amount of data to display. Use the Condition Builder to limit the data sampling or try another type of report. |
- Customize the style of the report created, and click Refresh.
- Click Save.
Info |
---|
To open the saved report, navigate to Reports → All Reports and select one from the list. |
|
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 customize the Multilevel Pivot report.
- Click Update Refresh to generate your build the report.
- Click Next Save to customize save 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.
- .
Info |
---|
Use the Condition Builder to establish additional conditions for data filtering and grouping. - Click the icon
Image Addedto open the Condition Builder. - Set the filters.
- Click Refresh to apply changes.
Image Added
|
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: - Average – counts an average number of the column values.
- Count – counts a number of entries.
- Count Distinct – counts
|
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:
Average;Count;Count distinct - counts - the number of unique values of the column
|
set in the Aggregation column;- .
- Sum – counts the sum of the numeric data values in this table column.
Info |
---|
The Sum and Average settings make sense if the aggregation column keeps the numeric data. |
The aggregation option selected is applied to the table column set in the Aggregation Column field. |
Aggregation Column | N |
Sum.Aggregation column | Select a table column with numeric values for data aggregation. |
Groups limit | The Aggregation Column is only available if the Aggregation Type option is Average, Count Distinct, Sum. |
|
Groups Limit | N | Define |
Set the limit of the data groups shown in your report with a particular number in this field. |
Show |
rest otherSet on to show the data groups not included in Groups |
limitLimit as one. Info |
---|
The Show Rest as Other is only available if the Groups Limit option is specified. |
|
Customize the style Anchor |
---|
| 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 Image Added to select the desired list view of the source table.
|
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 |
General Style |
---|
Report width | Low score color | Decimal precision | Title Style |
Report title show type | Set the type for the report title showing. |
Select one of the ; only; titleEnter Specify the title of the report you create. |
Report |
title sizeEnter Title Size | N | Specify the number of |
points pixels to set the size of the report title. |
Report |
title colorTitle Color | N | Select the color of the report title. |
Title horizontal alignment | Set the horizontal alignment of the chart title with one of the options: |
Title vertical alignment | Set the vertical alignment of the chart title with one of the options: |
Click the magnifier icon Image Added and, in the window appeared, select one of the available colors. |
Title Alignment | N | Select the alignment of the report title. Available options: - Left Top
- Left Bottom
- Right Top
- Right Bottom
- Center Top
- Center Bottom.
|
Bold Title | N | Select this checkbox |
Title bold | Switch this checkbox on to make the chart title bold. |