You can use the Reporter ribbon to quickly and easily personalize the Columns, Grouping, Sorting, Filters, and Totals of the displayed report to created a semi-permanent personal report that is only visible to you.
The options available depend on the report type.
Once you create a personal report, it becomes the default display for your account; however, you can easily switch back to the Shared report by clicking on the report and clicking Shared on the Reporter ribbon.
When the active report is a personal report, a person icon will be present in the title section of the Reporter web part.
To create a personal report:
The personalization options available depend on the displayed report type.
Select the columns to be included in the report and the order in which you want them to appear.
For each column, you can also set custom properties:
Custom column properties are lost if the column is removed from the report.
If you wish to use a custom column title for grouping purposes, the column must also be added to the report.
Columns listed here may not exist in all lists.
Select:
The column types you cannot use for grouping are: Multi-value, URL, Note and Icon.
Selecting Collapsed in any group means that all subsequent groups below that group will also be collapsed.
Select the column(s) you want to use to sort the items returned (i.e. the order in which the items are displayed in the report) and the direction you want them to be sorted.
The column types you cannot use for sorting are: Multi-value, URL, Note and Icon.
When you first open the personal filter dialog, you may notice that there are already filters there. This will happen if the report has shared filters defined, as the personal filter dialog will inherit these.
Click Reset on the personal filters dialog to remove any filters you added and restore the dialog to the default setting (including restoring the shared filter settings).
Select Display Captions to turn the totals captions on.
Totals Captions On
Totals Captions Off
Select the appropriate total option for the column in question.
When you are editing the settings of a personal report, the dialog header will display in yellow. With Shared Reports, the header will display in grey.