+ Reply to Thread
Results 1 to 5 of 5

Count incorrect in Pivot Table (Excel 2010)

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Ventura, CA
    MS-Off Ver
    Excel 2007
    Posts
    31

    Question Count incorrect in Pivot Table (Excel 2010)

    I have a calculated field in a data table with a simple IF equation that either returns a "Yes" or nothing (Elapsed time within 30 minutes (inclusive)). When that field is included in a Pivot Table, it counts all cells, ragardless of whether there is data in it. It should only count those cells with data.

    There is another field that calculates correctly in the Pivot Table (Communication).

    I have tried changing the cell format. I have tried refreshing all of the blank cells by hitting [Return]. I have tried re-writing the formula several ways.

    I have attached a sample of the Pivot table and data below.

    Data I expect in the Count of Elapsed time within 30 minutes field:

    Facility:1:
    Department
    D: 2
    E: 3
    C: 1

    Facility: 2
    D: 1
    E: 1
    C: 0
    A: 0
    B: 0
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Count incorrect in Pivot Table (Excel 2010)

    With a filter on the elapsed time.

    Also the facility added in the new file.

    See the attachment.
    Last edited by oeldere; 07-28-2017 at 02:29 PM.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    03-12-2014
    Location
    Ventura, CA
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Count incorrect in Pivot Table (Excel 2010)

    Thank you for that. I need it to be in the same table. I know that if I put that as a column label, I can sort it that way, but I need the all columns to appear as they do on the first tab.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Count incorrect in Pivot Table (Excel 2010)

    Then show manualy the result in your file, since I don't understand the question.

  5. #5
    Registered User
    Join Date
    03-12-2014
    Location
    Ventura, CA
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Count incorrect in Pivot Table (Excel 2010)

    Thank you.

+ 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. Count Number of Employees Per Month Using Pivot Table Excel 2010
    By mclarke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2017, 08:56 AM
  2. Count Number of Employees Per Month Using Pivot Table Excel 2010
    By mclarke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2017, 04:21 PM
  3. [SOLVED] Pivot Count Unique values - Excel 2010
    By ats1312 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-27-2017, 10:32 AM
  4. Add rows to table based on PIVOT table - Excel 2010
    By Pettaylor in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-27-2015, 08:49 AM
  5. [SOLVED] Count unique values in pivot table - excel 2010
    By Tino XXL in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2014, 04:45 AM
  6. Excel 2010 VBA: Last Row in Pivot Table
    By ajay_gajree in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2013, 08:10 AM
  7. Excel 2010 Pivot Table Returning Count of Blank Cells
    By snikrs11 in forum Excel General
    Replies: 0
    Last Post: 03-07-2011, 04:45 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