+ Reply to Thread
Results 1 to 3 of 3

Adding Calculated Field to PivotTable

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    63

    Adding Calculated Field to PivotTable

    Capture.JPG

    I'm wanting to add a field (which I've kind of done so far with the "Count of Compliance Rate") to my pivottable that automatically calculates Hands Washed/Total Observations. Once I get into the calculated fields options I'm kind of at a loss. Any help would be very appreciated, thanks

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Adding Calculated Field to PivotTable

    Please attach a sample workbook, so that we could see exactly what you're trying to achieve. Thanks

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Adding Calculated Field to PivotTable

    try this: https://www.excelforum.com/tips-and-...el-2007-a.html
    and this: https://askdrexel.drexel.edu/app/ans...-in-excel-2007.
    or this: https://www.youtube.com/watch?v=5dnmVA3cMQA

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculated field in PivotTable not doing as expected
    By marketshare in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2013, 05:52 AM
  2. PivotTable Calculated Field
    By Leeds in forum Excel General
    Replies: 1
    Last Post: 09-13-2011, 12:06 AM
  3. Pivottable adding calculated field?
    By Acro in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-15-2006, 12:11 PM
  4. [SOLVED] PivotTable:Using a calculated field result in another calculated f
    By Alice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-08-2006, 12:25 PM
  5. PivotTable - Calculated Field
    By Matt M HMS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2006, 11:55 AM
  6. Replies: 0
    Last Post: 09-27-2005, 11:05 PM
  7. PivotTable - Calculated Field Problem...
    By Sabotage1945 in forum Excel General
    Replies: 0
    Last Post: 02-17-2005, 12:23 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