Skip to Content
0
Former Member
Jan 06, 2008 at 04:55 AM

Help with summarized report

15 Views

Hi All,

I need to create a query which would give summarized result with respect to characteristics & KF's. For example, I want the report to be displayed like below (column wise):

Dept I Total Number of employeesI Total number of FTE's I Total number of Temps I Total Budget I

HR I 50 I 40 I 10 I $10,000,100 I

FI I 150 I 100 I 50 I $12,000,000 I

As seen above I need to total up employees, FTE's & temps with respect to Department. Right now there is a name for each employee like "greg, brian, stacey etc. And I need to total it up based on the Job Type ( FTE or Temp) & even total up the Budget. How can I do that. Can anyone please advice.

Thanks!!