You can set a query by department or category by completing the following steps:
Go to the Payroll module and click Query Setup.
Click New and enter a new Query ID.
Enable Use Custom Query and click the three-dotted button.
Scroll up on the left in the Custom Query window and search for Department.
Double-click Department and Employee.DepartmentId will be displayed in the right panel.
Type IN after the Employee.DepartmentId.
Type open bracket and select the department in the Select drop-down list. If you have more departments to select, type a comma followed by selecting in the select drop-down list for the next department.
Type a close bracket. The formula will now display as Employee.DepartmentId IN ('ADMIN', 'HR', 'FINANCE')
Click Save, apply this query and refresh your screen.