+ Reply to Thread
Results 1 to 2 of 2

Divide field item over another field item

  1. #1
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Divide field item over another field item

    Hello friends, hope all is well.

    Please open the attachment, and if you please help me with the pivottable.

    I want to divide the results of RV over the Visits.
    I can’t find the way.

    Really appreciate it in advance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-31-2015
    Location
    Barreiro, Portugal
    MS-Off Ver
    MS Office 365
    Posts
    84

    Re: Divide field item over another field item

    You can only do it for the whole field, not just parts of it.

    One possibility might be to create auxiliary columns, one for REV and other for Visits, use them in the pivot table, and with that you can do a calculated field.

    The other option, is simply to have that above the pivot table: =D16/D17.

    Hope it helps

+ 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. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  2. Calculated Field or Item
    By MarBoTJ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2015, 02:36 AM
  3. [SOLVED] Calculated Item or Field Help
    By rs1aj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-12-2014, 10:23 AM
  4. Replies: 2
    Last Post: 03-18-2014, 03:58 PM
  5. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  6. Replies: 1
    Last Post: 12-21-2012, 05:40 AM
  7. Replies: 2
    Last Post: 11-05-2012, 11:32 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