Create a portfolio view with sheet summary report

一个portfolio view pulls data from multiple sheet summaries. You create sheet summaries in the summary panel, then aggregate those summaries to create a portfolio view.

一个sheet summary report is different from arow report; a row report uses data from the cells in a sheet. Learn more about thetwo types of reports.

Tips for building a portfolio view:

• First,build the summary for each sheet.
• Make sure all your field names are consistent across sheets.
• Use the same field type across all summary fields used to collect the same data type. For example, if you’re aggregating budget information, ensure all columns in all included sheets have budget formatted as currency. If you have different field types, for example, currency and numeric, you’ll get a column for each field type.

Sheet Summary Report is not available for Premium Apps. For example, you cannot use a Sheet Summary type of Report as a source for your Dynamic View.

Create a portfolio view

To create a portfolio view, first, create a sheet summary report and then define what’s included.

Create your sheet summary report

1. On the leftNavigation Bar, clickSolution Center(plus icon) and then selectReport.
2. Type a name for your report, selectSheet Summary Report, and then clickOK.

Define what is displayed in the report

Use the settings on the report toolbar to adjust your Portfolio View.

Use this tab	To do this
Source Sheets	Specify which sheets and summaries will be pulled into this report. TIP: If you select a workspace, you get all sheets in that workspace. The report will update when sheets are added and removed from the workspace. Keep in mind that selecting a folder will only add the sheets in the folder; summaries on folders do not automatically update when the contents of the folder change.
Columns to Display	Select the summary fields or system columns for this report.
Filter Criteria	Define parameters for summary information displayed in the report.
Group	Combine similar values into groups to organize rows into logical categories or classifications.
Summarize	Extract key information from your report, such as the数of completed projects.
Sort	Define how summary information is sorted in the report.

Once you’ve configured each setting, selectSaveto confirm your selections. Summary data that meets defined criteria will be displayed in the report.

For more information about how each of these configuration options works, seeBuild a Row Report with Report Builder.

编辑custom sheet summary fields in the portfolio view report

You can edit the formatting of fields included in your portfolio view report right in the report; you don’t need to go back to the summary field in the underlying sheet to make changes.

1. Click theMoreiconon the left side cell of the row you want to modify, and select编辑.
2. The Sheet Summary form will open if the source sheet has custom fields. Otherwise, you will see "This sheet has no custom summary fields defined."
3. Enter your changes and clickSave.