For EmployeeID group - totals for type A

=Runningvalue(IIF(Reportitems!Type =
"A",Reportitems!Detailvalue,0),SUM,employeeID groupname)

For EmployeeRegion group -
=Runningvalue(IIF(Reportitems!Type =

Hi,

I have two groupings in my table. one based of employee_id and the other =
based on employee region. I am showing some values in the detail row of =
that table.

Now, I need to show the total of one field in employee_id group1 footer =
and employee_region group2 footer as well. the value that I display in =
detail field can be type a or b. so I need to show 2 totals for both the =
groups. How can I do this.

Group1:Header Employee_ID 1

Group2:Header Employee_Region Madrid
Detail Value:10 Type: B
Detail Value:10 Type: A
Detail Value:10 Type: B
Detail Value:10 Type: B
Detail Value:10 Type: A
Group2:Footer Total for Type A: 20
Group2:Footer Total for Type B: 30

Group2:Header Employee_Region Moscow
Detail Value:20 Type: B
Detail Value:20 Type: A
Detail Value:20 Type: B
Detail Value:20 Type: B
Detail Value:20 Type: A
Group2:Footer Total for Type A: 40
Group2:Footer Total for Type B: 60

Group1:Footer Total for Type A: 60
Group1:Footer Total for Type B: 90

My problem is in calculating Totals for Type A and B based on EmployeeID =
and EmployeeRegion.How can I do this

Any help on this will be appreciated

Thanks in Advance

Thanks Sonali.

Kiran

[quoted text, click to view]