Add the ability to disable the 'total' line and edit field (row) calculations on a Comparison & Summaries report

The column totals on the Comparisons & Summaries report calculate differently than the field (row) totals. For example, I built a Comparison & Summaries report based on gift size to compare # of donors at each level over the last five years. Gift size is not a cumulative calculation; therefore, one donor could be counted in more than one level. However, the column total is the distinct number of donors. Simple math shows that the field (row) numbers do not add up to equal the column number which makes people question the integrity of the report. We need the ability to disable the column total line and/or the ability to edit row calculations so that we can make it a cumulative calculation for each field.

  • Guest
  • Feb 5 2016
  • Attach files