Results 1 to 3 of 3

Pivot Calculated Field doesnt help

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2017
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    9

    Unhappy Pivot Calculated Field doesnt help

    I have a pivot table with my capex and opex hours in the columns with the names of project managers in the rows. the Capex and Opex hours are also summed into a column for a monthly total(see pic).

    What I need is an extra column at the end of each month that shows the capitalization rate which is just CAPEX/MONTHLY TOTAL in % however I can not figure out at all how to do this. none of the %Of options work to do this what is wrong?

    Any help is appreciated

    EDIT: I understand a sample worksheet would help but it would take an immense amount of time to create one with non sensitive info that would help so the pic is all I can provide.
    Attached Images Attached Images
    Last edited by yeetboygenius; 06-27-2017 at 10:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table: Calculated Field based on Running Total Field
    By EvolvingMonkey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 06:27 AM
  2. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  3. [SOLVED] A pivot table field calculated using other field values as fields?
    By chrisf78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2015, 03:08 AM
  4. [SOLVED] Referring to a Sub-Field on Calculated Field Pivot Table Column?
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-27-2014, 02:02 PM
  5. Replies: 1
    Last Post: 12-21-2012, 05:40 AM
  6. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  7. [SOLVED] pivot table formulas for calculated field or calculated item
    By Vicky in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 12:10 AM

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