• On the Format tab, select Details. Under Variance to Include, mark Increase.
       
    • In Excel, open the exported file.
     
    • Remove all columns except for the two giving period columns.
     
    • Create a formula that calculates the difference for each constituent's yearly giving. For example, if the yearly totals were in column A and B, to get the first difference, place the following formula in C1: '=B1-A1'.
     
    • Copy that formula to the remaining rows, updating the row numbers in the formula.
     
    • Average the difference values in the C column using the Average Function.