+ 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
    Excel 2016
    Posts
    36

    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
    Excel 2016
    Posts
    36

    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)

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