View Giving Trends Report
You can create a table to see all recipients of all appeals ever sent, and all responses to those appeals.
|
Displays a table of every contact who has ever received an appeal, and if they have given a gift. A contact who has received an appeal but did not give a gift is shown as a zero response. You can sort/filter the table using the Sorting & Filtering tools. (See tip below.)
|
| 2. | You can view the table in Excel. |
|
Send the table to Excel.
|
Tip: Sorting & Filtering
Current Group
| • | You can sort the Current Group by right-clicking in the list of contacts and selecting the sort order. |
Sort Task & History Tables
| • | Click on a column header to sort these tables. Click again to reverse the sort order. The grey arrow will indicate which column is being sorted, and in which order (ascending or descending). |
Filter Tables
| • | You can sort certain tables by any column, in an ascending or descending order. Do this by right-clicking in any column header or anywhere in the table and selecting "Sort Ascending" or "Sort Descending". (This does not work on all columns/tables.) |
| • | There are a number of filters you can use to shrink the size of your report. You can access this filter by right-clicking anywhere inside the report. |
Not all columns can be sorted or filtered. For example, columns that are made up of calculations generally cannot be filtered and will return an error message if you attempt to sort or filter.
Sort Ascending
Sort Descending
|
Sorts list in alphabetical order by last name (regardless of which field your cursor is in). To sort a specific column, you must have your cursor in the column heading before right-clicking.
|
Filter By Selection
|
Shrinks the list to show only contacts with the last name you have selected. (Or whatever field you were in when you right-clicked.)
|
Filter Excluding Selection
|
Removes all contacts with the last name you have selected.
|
Filter By Value
|
Allows you to enter the last name to filter on (the same as scrolling down to that person and selecting them).
|
Remove Filter/Sort
|
Returns report to its original appearance.
|
Customize Filter
|
Using query language, you can write a custom filter (advanced)
|