adding multiple fields/columns in a pivot table

Hello Excel Experts,

I have a question regarding pivot table formulas and adding/grouping multiple fields and columns with the total for the groups displaying at the far right of a pivot table.

I've tried using the calculated item/field feature but cannot get it to show what I want. For what I want to do, I’m not sure if calculated field/item would be the right thing. This problem may require a macro/vba script although I’m uncertain at this point. I've searched quite a bit on this forum and the internet and cannot find the answer.

What I have is a payroll report with a listing of employee names, whether a payment is regular/overtime, and deductions. The report I receive from the company system is quite big with a listing of many employees. Using this source data, I have created a pivot table to display the total earnings, deductions etc.. What I would like to see are grand total columns at the end of the pivot table summarizing the numbers in the pivot table. I'm wondering if there is a way for these grand total columns to be part of the pivot table and not outside of the pivot table - like a calculated field.

I have included a sample of the report with the source data I receive and a pivot table based off the source data.

I would also like certain numbers to not be displayed in the pivot table which I’ve marked by arrows in the sample excel sheet.

Any help would be greatly appreciated.