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!!