+ Reply to Thread
Results 1 to 2 of 2

Need to add a calculated field on Pivot Table

  1. #1
    Registered User
    Join Date
    02-21-2018
    Location
    Salem, NH
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    5

    Need to add a calculated field on Pivot Table

    I have a table with 2017 quantity and cost $, and 2018 quantity and cost $ - but when I try to add 2 calculated fields to compare quantity and $ value year to year I can't get it to do it I think because my two years, quantities and Cost $ are in the same column in the data sheet so i can't pick 2018 Qty - 2017 Qty as my only column is Qty, cost $, and Year.
    What's the workaround to get those calculations?

    I've attached a sample file with the two calculated columns I need on the right - but I have way too many rows to do them all manually one by one as you can't copy and fill that down either.

    Thanks,
    Joann
    Attached Files Attached Files

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

    Cool Re: Need to add a calculated field on Pivot Table

    maybe without PivotTable but with PowerQuery (Get&Transform)

+ 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. Pivot Table Calculated Field: Different categories in the same field
    By happydays886 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-08-2016, 09:49 PM
  2. 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
  3. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  4. [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
  5. [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
  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