GH1 - Dept

GH2 - Problem  (each dept has a list of problems they resolve)

My goal is to total the # of problems reported in 2009 by problem type (GH2) within each dept(GH1)

 

For ex: 

HR Dept

   Union issues          5  (GF2)

   Personnel issues   3   (GF2)

Total for HR               8   GF1c

 

I need totals by the problem type (GF2) under each dept as well as the total for the dept in GF1c. 

 

I placed the following formula in the detail line called @Count_2009:

if Year({CUSTPROB.PROBDTTM})=(Year({?EndDate})-1) 
then 1 else 0

 

I then placed this formula in GF2 called : @TotalCount2009

sum({@Count_2009}, {CUSTPROB.PROB})

 

Can anyone help me to get the total for each dept which in GF1c?

 

Thanks in advance!

---

 

 

 

One additioonal question I forgot to ask.  When I need the Grand total  of all departments what formula would I use?  The grand total of all departments in in RFa.  Thanks for helping.