Write, Bureaucrats, Administrators
1,171
edits
Difference between revisions of "How to customise reports"
no edit summary
(Created page with "ExcelReportLink solutions use ExcelPivot Tables and Excel Query Tables to display the data. == How to filter data for specific elements == The dimensions included on...") |
|||
| Line 1: | Line 1: | ||
ExcelReportLink solutions use Excel[[Pivot Tables]] and Excel [[Query Tables]] to display the data. | ExcelReportLink solutions use Excel[[Pivot Tables]] and Excel [[Query Tables]] to display the data. | ||
== How to filter data for specific elements == | == How to filter data for specific elements and columns == | ||
The dimensions included on the reports can be filtered to only show what is required. To do so, follow these steps. | The dimensions included on the reports can be filtered to only show what is required. To do so, follow these steps. | ||
| Line 8: | Line 8: | ||
# Untick the elements to exclude; | # Untick the elements to exclude; | ||
# View the report. | # View the report. | ||
== How to change the columns on reports == | |||
Additional dimensions and fields can be added to the reports. To do so, follow these steps. | |||
# Click on the report; | |||
# From the fields on the right, drag the necessary field and drop then in the '''Filters''', '''Rows''', '''Columns''' or '''Values''' section. | |||
=== Notes === | |||
* You can position the fields in the list to control the order they show on reports. | |||
==Related topics == | ==Related topics == | ||
* [[Publishing Reports]] | * [[Publishing Reports]] | ||