With Advanced Reporting in Silent Partner Cloud, you can create custom reports and dashboards and share those reports with ease.

Open Advanced Reporting 

To create a new report, click "New."

For this example, we will build a report of total donations for each year, broken down by donor type.

The report builder will open to the Data Sources tab. In this example, we will be building a donation report, so you can check the box next to "Account Activity Donation Details," or use the "Recent Data Sources" drop down to select it.

Next, got to the Fields tab. In the Field drop down, select Donor Type and select Group under Function. This will group the results of your report by donor type. In the second line, under Field, select "Donation $," and in the Function drop down, select "Sum." Next, click the Add Pivot Button.

Some new options will appear called "Add pivot columns for" and " Calculate cell values on." Next to Add pivot columns, select "Donation Date," then use "Group (Year)" for the function. Next to Calculate cell values on, select "Donation $," and use "Sum" as the function. This will add a column to your report for each year with a total for each year by Donation Type.

Finally, click the "Add Side Total" option. This will add a final column with the totals for each row (Donor Type) in your report.

To restrict your report to a specific number of years, go to the Filters tab. In the first line under Filter Field, select "Donation Date." Under Operator, select "is Greater Than" and enter "2014" in the Value(s) field. This will restrict your report to only show results for 2015 onwards.

To give your report a name and save it, go to the Misc tab and give the report a title that will appear on the report. We'll call it Overall Results by Gift Source - Revenue.

Next, go to the Preview tab and your report will run in preview mode.

Finally, click the Save Icon. In the pop-up window that appears, type in a report name and select which Category you want to save the report under. This is how you will find the report in the list of available reports. We'll call it Overall Revenue by Gift Source - Revenue.

This is the report, although your numbers will be different!

In this example, we'll modify the report to provide total number of donors each year for each donor type. 

Click "Save As" and rename the report Overall Results by Gift Source - Number of Donors. This is how the report will appear in the list of available reports. It will save in the same category unless you select a different category in the second drop down.

On Misc tab, change the Title to Overall Results by Gift Source - Number of Donors. Remember, this is the name that appears on the report.

Preview the report and you'll see it provides a count of donors for each Donor Type for each year. Again, this is just a preview, so your actual numbers may be different.

If you would like to create a Dashboard using these reports, refer to our article on  Creating and working with Dashboards in Advanced Reporting.