+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Calculation (Measure) Formula Help

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    Pivot Table Calculation (Measure) Formula Help

    Hello. I have a ratio column. Sales / jobs = Ratio

    Everyday it updates, meaning +1, the next day -3

    I would like to have a graph of this ratio starting from the day 1.

    Basically, its A2-A1= but How can I have this formula in Pivot table Calculation field?
    Attached Files Attached Files

  2. #2
    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: Pivot Table Calculation (Measure) Formula Help

    Hi,

    Right-click the field, choose Show Values As, Difference from, and then change the bottom dropdown to 'Previous'.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    02-12-2018
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2013
    Posts
    4

    Re: Pivot Table Calculation (Measure) Formula Help

    Hi Sovietchild,

    xlnitwit is correct, although you may also need to make a selection in the frame to the right of where you made the selection 'previous'. Based on what I see in your file, you have not included labels so your pivot table just says 'column 1' in the rows area. This is the one you may need to select.

    Hope this 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. Power Pivot: Adding a measure to a Pivot Chart
    By jlt199 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-22-2017, 12:40 PM
  2. Powerpivot Calculated Measure to remove blanks from pivot table/chart
    By hbusche in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2013, 01:23 PM
  3. Calculated pivot table field using pivot table data in calculation
    By BrittleStar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2012, 05:35 PM
  4. Replies: 1
    Last Post: 11-29-2011, 10:52 PM
  5. Pivot Table Calculation
    By briandrago in forum Excel General
    Replies: 2
    Last Post: 01-29-2009, 05:27 PM
  6. Replies: 1
    Last Post: 06-19-2006, 03:25 PM
  7. How to Add a Calculation to a Pivot Table ?
    By Barb Reinhardt in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 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