Results 1 to 6 of 6

Calculate Total Pay Using Pivot Table Calculated Fields or VBA Macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2011
    Location
    Candada
    MS-Off Ver
    Microsoft Office 365
    Posts
    174

    Calculate Total Pay Using Pivot Table Calculated Fields or VBA Macro

    Happy Greetings from wherever you are,
    I have a pivot table that calculates regular and overtime hours worked by each employee on a weekly basis. I would like to know if there is a way of obtaining the Total Pay either by using an Excel pivot table calculated fields or an Excel VBA code to first multiply regular hours by $1.00 and overtime hours by $1.50 and finally adding the regular and overtime pay in a column next to the pivot table. Right now I can accomplish this task by calculating the total pay by multiplying regular hours (REG) by $1.00 dollar and the OT by $1.50 dollar and then summing up Regular Pay and Overtime Pay. The issue that I have with this approach is that as the pivot table adds more data or rows, I have to constantly drag down the formulas in columns G, H and I. I appreciate your shared knowledge and time to help me and others.
    See attachment for better explanations.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculated field using the Grand Total and Values fields of Pivot chart
    By krissysteen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-01-2018, 04:25 AM
  2. VBA code to calculate pivot fields to create calculated field programmatically
    By dougmcc1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2015, 09:18 PM
  3. Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  4. [SOLVED] Pivot table calculated item doesn't calculate on Grand Total
    By nfcascalheira in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-27-2014, 08:10 AM
  5. Calculated Fields in a Pivot Table
    By rkrieg in forum Excel General
    Replies: 3
    Last Post: 07-18-2011, 07:45 PM
  6. Pivot Table calculated fields
    By tigertim71 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2008, 04:58 AM
  7. [SOLVED] Erroneous Grand Total of calculated fields in pivot table
    By JP in forum Excel General
    Replies: 3
    Last Post: 01-26-2006, 01:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1