+ Reply to Thread
Results 1 to 2 of 2

making a formula to do comparison for pivot table

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    94

    making a formula to do comparison for pivot table

    Hello

    I'm struggling to get a formula in which I can drag down for the whole column.

    In the provided attachment in "Pivot Table 2", I have a sample Pivot table and I'm trying to write a comparison formula in which it compares the value of one column versus another. However, when I write the formula for the first one and try to do a click-and-drag to copy to all of the cells in the comparative column, Excel is not updating with the rows in the formula.

    Is this even possible in Excel or am I doing something wrong?

    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    94

    Re: making a formula to do comparison for pivot table

    Hello,

    So, I watched the provided Youtube link, and it suggests several options, including using the "Calculated Field" option to calculate what I would like to do.

    However, it seems that when I use the "Calculated Field" for figuring out whether the number for one Pivot table column is greater than another Pivot table column, the logic is incorrect.

    Why would that be the case?

    PS: Unfortunately, I'm unable to upload my Excel file, but if that changes, I will upload the Excel file here.
    PPS: Sample file uploaded and the changes that I made can be seen in the tab "Pivot Table 2", column E
    Attached Files Attached Files
    Last edited by dcwan; 09-12-2019 at 09:59 PM.

+ 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 last year comparison
    By demirci in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-31-2018, 08:08 AM
  2. Problems making a formula for pivot table.
    By rolex in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-04-2015, 08:06 PM
  3. day on day variance comparison using pivot table
    By yelllowsubmarine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2015, 09:44 PM
  4. Pivot table Sales comparison over years
    By Holymoly in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-25-2013, 11:21 AM
  5. Help with comparison chart / pivot table
    By coreytrillo in forum Excel General
    Replies: 3
    Last Post: 03-14-2011, 09:06 PM
  6. Pivot Table row comparison
    By revm2 in forum Excel General
    Replies: 2
    Last Post: 11-02-2005, 06:17 PM
  7. [SOLVED] pivot table comparison
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2005, 11:06 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