asked on

Helping building a cross-tab report in Crystal

I am trying to build a crystal report that compares charitable donations between last year to date and this year to date. I can use a filter If contribution date in {range last calendar year} then contribution amount which will give me the total donated for the previous year to date sorted by list code. However, I can't figure out how to get the numbers of donations for each list code to come out.
I've tried using the count of list code with the same formula, but all I get is the total number of contributions over the entire period, rather than the number of contributions for the last year to date (by the way the list codes are text, not numbers).
Any suggestions would be greatly appreciated.

Marcus Aurelius

Use something like the RECORDNUMBER to either COUNT or DISTINCT COUNT on...in the Crosstab.

Please provide a simple example of what you are trying to achieve....

Thanks
MIkeV

changingourworld

ASKER

I am trying to acheive a table that looks like the following:

List Name Total Donations # of Donations Average Donation
Previous Year To Date (PYTD) (PYTD)
(PYTD)
AAA $$$$
BBB $$$$
CCC $$$$

Thanks.

Marcus Aurelius

To get the number of donations..you need INSERT A SUMMARY field to COUNT ON. I don't know what this is..but it can be a RECORD# or INVOICE# etc..

To get the YEAR OVER YEAR COMPARISON...I would ADD YOUR DATEFIELD as a column.....and set it to group by YEAR.

You can do the same thing in the ROW it just depens on how you want your crosstab to look.

To get the Average...place the SAME FIELD that you used to COUNT on in the SUMMARY area...and this time do an AVERAGE.....

You follow?

MIkeV

changingourworld

ASKER

That was the direction I was trying; however, while I can get the previous year to sum the donations, when I try and use a formula to count the appeals when limiting the date range, all the records are counted the formula I am using is for the column and the row is Gf.GF_Appeal

if {Gf.Gf_Date} in LastFullMonth then {Gf.Gf_Appeal}

ASKER CERTIFIED SOLUTION

Marcus Aurelius

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial