How to add in a count of PEOPLE…Example – Annual Leave count:
How to add in a count of PEOPLE…Example – Annual Leave count:
|
Open the Payroll Assignment Spreadsheet
|
|
|
Refresh with all codes – active Assignments
|
|
|
Set your pivot table so that the Full Name is listed. Pull down the Annual Leave column to the left.
|
|
|
. To see a list of all employees with an Annual Leave of Y, filter on the Annual Leave column and select “Y”
|
|
|
Right Click and select “Show PivotTable Toolbar”
|
|
|
Make sure your cursor is in the pivot table and then click on the “PivotTable” drop down arrow on the pivot table toolbar and select Formulas and then Calculated Field
|
|
|
Title your field as “People Count” and make the formula
=1
Click OK
Note – in order for the People Count to be correct, you need have the FullName as the only field on the pivot table (for example, you can’t add in full account code or job codes and get the correct count.
|
|
|
The People Count field will appear in the pivot table. Note however that the grand total is not computed. This is unfortunately the way excel works. We can however create a running count
|
|
Related Articles
Position Counts for Salaried Positions – Payroll Assignments
Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in all employees that are coded as Salaried. Note that this will also bring in supplemental and ...Position Counts for Salaried Positions – Payroll Assignments Spreadsheet
Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in all employees that are coded as Salaried. Note that this will also bring in supplemental and other ...Payroll assignments - how do I see last FY's assignments?
The short answer is there is no way to do this UNLESS you already know the following. The payroll assignment spreadsheet is not "date driven" - meaning on the settings tab, there are no dates, see screen print below: When payroll assignments is ...Obtaining Counts for the SS300 Report using Payroll History Spreadsheet - Sartox
Obtaining Counts for the SS300 Report using your Payroll History Spreadsheet - Sartox Select the year that you need to obtain information for. Select “List of Object Codes” from the drop down list. List all of the object codes that apply to the ...Obtaining Counts for the SS300 Report using Payroll History Spreadsheet - LINQ
Obtaining Counts for the SS300 Report using your Payroll History Spreadsheet - LINQ Select the year that you need to obtain information for. Select “List of Object Codes” from the drop down list. List all of the object codes that apply to the ...