Need to sum a "pre summed" value in group headers

[agray123]

I have a report that is looking at the number of job reclassifications by division (made up of specified groups of Dept ID's).

In the query I am pushing into Crystal, I include a field that shows the total number of allocated positions for each department so I can run the count of emplid's that recevied a reclass against the total number of allocated positons for each department (and then each division) and get a %

How can I keep the positons allocated "distinct" rather than showing up like this:
Eff Date DeptID ID Apprvd Cnt
2001-01-20 2330 492129 19
2001-09-25 3520 055131 57
2001-09-25 3520 093636 57

I am grouping by Fiscal year (from Ef Dt)
Then by Division (Selected Dept ID's)
Then counting emplids and getting a gropu sum.

When I sum Apprvd cnt, I get a huge number (57+57+57 and so on)

How can I get a conditional sum of Dept ids into the group header for breakdown?

 

[lbass]

You could use a running total of {table.approvedcnt}, sum, evaluate on change of field {table.deptID}, reset on change of group (division). But, this would have to be displayed in the group footer, not header.

The other option you might try is a crosstab in the group header.

-LB