I don't know if anybody is really familiar with Crystal Reports Formula Generation, but I'll give this a shot.

I have a report, it displays a list of different cities in the United States and the cities are organized and group by state. (IE Charlotte, followed by Raleigh are under North Carolina). Now then, I have a total for each city listed next to that city, seperate by year. Like so..

NORTH CAROLINA
Charlotte 10,000
Raleigh 20,000

TOTAL FOR NC - 2001 XXXXXXX

Charlotte 15,000
Raleigh 5,000

TOTAL FOR NC - 2002 XXXXXXX

My problem is I can't seem to work the formula section right to generate just the total for that specific state in that specific year. I have all 50 states listed and when I try to get the sum of that Program Amount Field, I get the total for the entire united states instead of just that state. Can anybody give me a hand?