7 Replies Latest reply on Dec 6, 2017 9:18 PM by David Woodley

    Counting values over years from Sign Calculation

    David Woodley

      Hi all

       

      I have found a few similar discussion related to sorting Grand Totals, but not exactly what I am looking for.

       

      I have set of donors, some who give many times a year over many years.  I only need to count such gifts in any year as a "positive value". I used a sign calculation form this and applied the "gift date" to columns.  However, the Grand Total column, which counts each "positive" year of giving is not sortable.  I can see the sort button.  Clicking does nothing.  If I switch the "total using" from Sum to Automatic, it changes the grand total value to one.

       

      Any thoughts on how I can make the Grand Total sort descending?

       

      Screen Shot 2017-12-06 at 9.58.30 AM.png