From the reports tab, click New Report.
Choose a Report Type, then click Continue. (The report type you choose determines which records your report returns.
The Lightning Report Builder opens in edit mode, and shows a preview. Customize your report to show exactly the data that you need, by adding or removing fields.
To add a column (field) to your report,
Type the name of the field in the Add column lookup. Then click the field.
You can also drag-and-drop a field onto the Columns list or directly onto the report preview.
To remove a column (field) from your report,
From the Columns list, find the column you want to remove. Then click .
The columns are extremely easy to move around. Just drag and drop to the spot you would like them to be.
To remove all columns from your report, from the Columns list, click .
Removing a column from your report doesn’t delete the field. You are able to add it again.
To see all available fields: Open the fields pane.
To summarize a column in your report:
From the Reports tab, edit a report. Click More Actions | Edit.
From the preview pane, find the column you want to summarize. Click | Summarize, and then choose how you want to summarize the column: Sum, Average, Max, Min.
You can use groups in the following ways.
To set up default sharing access via a sharing rule
To share your records with other users
To specify that you want to synchronize contacts owned by other users
To add multiple users to a Salesforce CRM Content library
To assign users to specific actions in Salesforce Knowledge
To group records (rows) in your report,
Enter the name of a (field) in the Add group look up under GROUP ROWS.
After grouping a row, you can group a column by choosing a column from the Add group pick list under GROUP COLUMNS.
To ungroup records (rows), click x.
From the Groups list, find the group you’d like to ungroup and then click .
Alternatively, drag-and-drop the group onto the preview pane.
To ungroup all groups in your report, from the Groups list, click .
To do math
Click the Columns Action menu, then choose a function from Summarize.
To filter records from your report, click FILTERS.
To add a field filter, type the name in the Add Filter look up window
Then set filter operators and values , click Apply
To edit a filter, including standard filters, click the filter.
To remove a filter, click the icon on the filter.
To add a chart, first add at least 1 group, then click Add Chart.
A chart appears. To customize the chart, click .
Change the chart type, color palette, and more.
To show or hide the chart, click .
To remove the chart, click | Remove Chart.
Click Save. If you’re creating a brand new report, give it a name. Optionally, give it a description. With access and sharing in mind, save the report in an appropriate folder.
To view complete report results, click Run or Click Save & Run to view.
Save it into a folder