Report Builder
You can add rows from multiple sheets into one report with a row report....
On a new report, the source sheets selection window is open by default....
When you build a report, you first select the source sheets. Next, you select the columns. At the top of the report, select Columns....
Your report's filter is comprised of multiple filter groups, which contain the conditions that rows must meet....
You can group your data to combine similar values, this way rows are organized into logical categories.
How your data will be sorted depends on its data type....
Select the Summarize tab on the toolbar to open the Summary settings. Choose the fields you’d like to summarize. Select how you’d like to ...
Your reports stay connected even when column names in underlying sheets have changed.