+ Reply to Thread
Results 1 to 2 of 2

Find Difference in Two Count Fields???

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    294

    Find Difference in Two Count Fields???

    I have a pivot table where (among others) there are two calculated fields; each counting the occurrence of dates. I am simply trying to find the numeric difference in these columns via another calculated field. Any help is greatly appreciated.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: Find Difference in Two Count Fields???

    Can't you just subtract one from the other?

    Pete

+ 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. PivotTable:Stumped by simple % difference between two fields - help!
    By TeamIDFC in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-22-2013, 05:11 PM
  2. Difference between 2 calculated fields showed as % of grand total
    By dot238 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-02-2013, 10:05 AM
  3. Sorting by "Difference" results between two Date/Time fields
    By RitaB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 03:19 PM
  4. Replies: 1
    Last Post: 10-19-2012, 02:08 PM
  5. [SOLVED] Calculated fields based on date difference
    By mrmyr in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-20-2012, 04:54 AM
  6. Count of Difference Between two numbers.
    By hafeezcloud in forum Excel General
    Replies: 4
    Last Post: 08-30-2012, 07:36 PM
  7. How to Disable automatic fields in pivot table like total and count on fields
    By anushka in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-24-2009, 07:53 AM
  8. Replies: 0
    Last Post: 11-28-2007, 07:03 AM

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