+ Reply to Thread
Results 1 to 2 of 2

add calculations to a pivot table

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    541

    add calculations to a pivot table

    I have a column that shows times of transactions. I would like to add a field that calculates the gap between those two times. It would be like c6-c5= whatever and on down the data set. How can I do this?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: add calculations to a pivot table

    Delete Calculated Field "Gap"
    Instead create a new field "Gap" in your data with the formula "=VALUE(B2)", as the "Conf.t." field are not numbers
    Pull this "Gap" field to Values section of the PivotTable
    => Summarize Values By "Sum"
    => Show Values As "Difference From"
    => Base Field: "Conf.t.", Base Item: "previous"
    => OK
    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. Pivot Table with Calculations
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 01-05-2018, 04:55 PM
  2. Replies: 1
    Last Post: 03-23-2017, 03:53 PM
  3. Replies: 5
    Last Post: 05-02-2012, 02:26 PM
  4. Excel 2007 : Pivot table calculations
    By interested in forum Excel General
    Replies: 11
    Last Post: 12-30-2011, 07:21 PM
  5. Excel 2007 : Pivot table calculations
    By Dubbelito in forum Excel General
    Replies: 1
    Last Post: 02-25-2011, 08:26 AM
  6. Pivot table and calculations
    By Horia in forum Excel General
    Replies: 5
    Last Post: 07-16-2010, 02:30 PM
  7. [SOLVED] add:Pivot Table Calculations
    By PB in forum Excel General
    Replies: 2
    Last Post: 11-25-2005, 03:25 PM

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