+ Reply to Thread
Results 1 to 6 of 6

Pivot Table Calculated Field Formula

  1. #1
    Registered User
    Join Date
    02-15-2016
    Location
    Manchester
    MS-Off Ver
    2013
    Posts
    17

    Pivot Table Calculated Field Formula

    Hello,

    Trying to get my head around which formula to type for a Pivot Table Calculated Field that sums partial columns.

    The desired end results is on the table on the right, which was done manually.

    Pivot Table Calculated Field.jpg

    Thank you.
    J

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,442

    Re: Pivot Table Calculated Field Formula

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    02-15-2016
    Location
    Manchester
    MS-Off Ver
    2013
    Posts
    17

    Re: Pivot Table Calculated Field Formula

    Apologies,

    I am not able to attach a file, for some reason.

    Here is a sample of the data
    Thank you
    Last edited by Pepe Le Mokko; 04-22-2020 at 02:18 AM. Reason: Removed data - Sheet attached

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,442

    Re: Pivot Table Calculated Field Formula

    If you follow the instructions on the yellow banner, you can attach a file, like everybody does.
    The paper-clip does NOT work
    Your sheet should contain AND some data, AND expected results ( eventually added manually).
    Thank you for helping us help you

  5. #5
    Registered User
    Join Date
    02-15-2016
    Location
    Manchester
    MS-Off Ver
    2013
    Posts
    17

    Re: Pivot Table Calculated Field Formula

    Thank you.

    file attached w/ sample data
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-24-2020
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    95

    Re: Pivot Table Calculated Field Formula

    Hi, there

    According to your mockup calculations, what you need is "Calculated Item"
    ribbon.pngItem.png

    pls refer to attached file for more details (columns in yellow)
    Attached Files Attached Files

+ 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 Pivot Table (Formula needed)
    By Cubicle Convict in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2017, 07:15 PM
  2. Formula in Pivot table calculated field
    By Keshypops in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2016, 02:29 AM
  3. [SOLVED] Using a MIN, MAX formula on a calculated field in a pivot table
    By fhaberland in forum Excel General
    Replies: 1
    Last Post: 01-20-2016, 06:07 AM
  4. [SOLVED] Formula for Calculated Field in Pivot Table
    By reshi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2015, 02:15 AM
  5. ----------
    By MGadAllah in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-30-2015, 04:13 AM
  6. [SOLVED] Pivot table calculated field countif formula
    By IronCladRooster in forum Excel General
    Replies: 2
    Last Post: 04-22-2015, 01:49 PM
  7. [SOLVED] Edit the formula in a calculated pivot table field
    By dmascola in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2013, 08:35 PM

Tags for this Thread

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