+ Reply to Thread
Results 1 to 8 of 8

Calculated fields; sum of three fields compared with a 4th

Hybrid View

  1. #1
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Calculated fields; sum of three fields compared with a 4th

    Hi,

    You need two calculated fields.
    Select a cell in the pivot table and on the PivotTable Tools - Options tab, click the 'Fields, Items and Sets' dropdown and select Calculated Field.
    Choose a name and use the formula: ='GR Restate' +'Fed Change' +'PAC Trnsfr'
    Then add another field using the formula ='Bud Diff to Load' -Col4 (where col4 is the field you added first of all)
    Finally position the fields wherever you like.
    Attached Files Attached Files
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. [SOLVED] Pivot calculated fields - dropping needed fields without dropping calculations
    By Aly1978 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-15-2017, 10:25 PM
  2. Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  3. Calculated Fields
    By trisoldee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2015, 01:26 AM
  4. HELP Reg Calculated Fields
    By sunvin in forum Excel General
    Replies: 8
    Last Post: 07-09-2008, 01:45 PM
  5. [SOLVED] Calculated Fields Based on Running Total Fields?
    By Kruncher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2006, 01:25 PM
  6. [SOLVED] Calculated fields
    By nc in forum Excel General
    Replies: 0
    Last Post: 05-09-2006, 09:50 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