I am trying to get the top ten percapita donations based on chapters. The data includes:
ID
Donation Date
Donation Amount
Total Membership
The report is grouped by chapter to allow for summary caluctions. The report has five formulas that look at the date of the donation and if it meets the parameters includes the amount of the donation. The sum of that formula displays for each chapter for the past five fiscal years (7/1 -6/30 for fiscal year).
There is a second formula that takes the last year's donations and divides it by the number of member to give me the percapita donations. This is the field that I would like to be able to use t0 show the top 10, and it is not allowing for that.
Any ideas?
Colleen
ID
Donation Date
Donation Amount
Total Membership
The report is grouped by chapter to allow for summary caluctions. The report has five formulas that look at the date of the donation and if it meets the parameters includes the amount of the donation. The sum of that formula displays for each chapter for the past five fiscal years (7/1 -6/30 for fiscal year).
There is a second formula that takes the last year's donations and divides it by the number of member to give me the percapita donations. This is the field that I would like to be able to use t0 show the top 10, and it is not allowing for that.
Any ideas?
Colleen