Results 1 to 3 of 3

Subtracting one sum of counts from another sum of counts in a pivot table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-07-2019
    Location
    london
    MS-Off Ver
    2013
    Posts
    105

    Subtracting one sum of counts from another sum of counts in a pivot table

    Hi
    very much would appreciate assistance.
    i have a pivot table with the sum of the count of product LL under the row being the outcome of WIN and the sum of the count of product LL under the under the row which is outcome of LOSS.
    i have attached what i mean here

    i am trying to create a new field column that creates the calculation of A. the count of LL of WINS which is 7 subtraced by B. the count of LL of LOSS which is 1 to = a new "result" filed that should obviously show 6

    unfortunately no success with this despite much searching through the web over a few days , can anyone help with this - it would be greatly appreciated.

    thanks

    steve r
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to sum counts from a certain pivot table
    By Horrid Wilting in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-06-2018, 03:21 AM
  2. [SOLVED] Pivot Table Help - Counts
    By degross77 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-09-2018, 04:01 PM
  3. Please help! How to tell which counts are the same in pivot table
    By dukepoco224 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2015, 01:59 PM
  4. Pivot Table Unique Counts
    By plum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2010, 04:42 PM
  5. Pivot table - SUM of COUNTS?
    By nick_danger in forum Excel General
    Replies: 1
    Last Post: 03-10-2008, 11:43 PM
  6. [SOLVED] Pivot Table - Average of counts
    By Dan in NY in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  7. [SOLVED] Pivot Table - Average of counts
    By Dan in NY in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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