Formula to summarize yearly date on same row. 1

[scottpdann]

I want to summarize my data as follows:

Donor|2007 Contributions|2008 Contributions|2009 Contributions

What is the formula to put each year's summarized contributions in a column?

Thank you for your help.

 

[CoSpringsGuy]

probably need more information but ..

group by doner
create three formulas
//2007 contributions
if year({contributiondatefield}) = 2007 then {contributionamount}
else 0

do the same for 2008 and 2009

sum({@2007contributions},{donor})
repeat for 2008 and 2009

place those in columns in the group footer.

hide your details


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Or you could insert a crosstab in the report footer that uses {table.date} as the column field->group options->print on change of year, donor as the row field, and sum of contributions as the summary.

-LB