Total no of HRMEmployeeType?

How can i display the total no of Employee,Contractor,WorkCenter(HRMEmployeeType) for each location?

Group by the type and find the count…

Are you finding any difficulty in doing that???

Yes Kranthi,i have written query as below in the “AddressCountryRegion” table,but i’m not getting count correctly. select count(recid) from tAddressCountryRegion where tAddressCountryRegion.CountryRegionId == this.CountryRegionId join tDirPartyTable where tDirPartyTable.EmpCountry == this.CountryRegionId Join templtable where tEmplTable.PartyId == tDirPartyTable.PartyId join tHRMPartyEmployeeRelationship where tHRMPartyEmployeeRelationship.EmplId == tEmplTable.EmplId && tHRMPartyEmployeeRelationship.EmployeeType == HRMEmployeeType::WorkCenter; return tAddressCountryRegion.RecId;

You have to find out the count of recId’s from EmplTable- so re structure your select statement according to that…