Build a row report

With a row report, you can:

• Create filters for relevant information in a sheet
• Restrict users to editing only the important columns or rows
• Combine information from multiple sheets into a single report

There are two types of reports:

• Row report: Add rows from multiple sheets into one report
• Sheet summary report: Add multiple sheet summaries into one report

If you’re building a sheet summary report, readCreate a Portfolio View With a Sheet Summary Report.

创建一个行报告

1. On the leftMenubar, selectSolution Center.
2. Then, clickCreate>Report.
3. Create aRow report. You’ll find your new report in the sheets folder.

Configure the report

If you are working with large amounts of data, consider applying additional summary filters to the report when you configure it.Sheet name,Created (date), andModified (date)can limit the data included and help your reports run more efficiently.

Use these tabs to set up the information you need to add in the report:

• Source Sheets- Select the sheets which have the data you need for your report.
• Columns to Display- From the source sheets, select columns you want to add to your report.
• Filter Criteria- Identify the data your report should pull from the source sheets.

The filter shows requests to be delivered via email.

• Group- Categories help you easily access the information you need.

• Summarize- Define key metrics to help you make informed decisions.

Similar to this example, you can summarize information according to their status.

• Sort- Arrange the information in a particular order.