Determining Salary amounts for particular object codes – comparing increases

From the settings tab, select Date Range.

Enter beginning and ending dates and Refresh.


Go to the Payroll History pivot table.

Filter on Fund 1


Filter on object codes needed


Click on the headers for Payline Gross and drag up and to the right until you see the red X and let go.






Also drag off the Net Pay, Hourly/Daily Rate, Total Hourly Pay, and Escrow columns. This should leave only the Net Gross Amount on the data portion of the pivot table.



Drag the Purpose and Purpose Desc columns up to the top portion of the pivot table.

Click on the Full Name in the top portion of the pivot table and drag to the right of the Object Desc on the pivot table – watch for the grey T to appear before letting go



Click on the Pay Period Beginning Date on the top part of the pivot table and drag ON TOP OF the NET GROSS heading and let go.




This will provide you with a list that shows side by side the monthly amounts for employees in the desired object codes.