+ Reply to Thread
Results 1 to 3 of 3

Pivot Table to count missing fields

  1. 04-07-2016, 09:21 PM #1
    pantaloc
    pantaloc is offline
    Registered User
    Join Date
    04-07-2016
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    5

    Question Pivot Table to count missing fields

    Hi guys, I'm very new to pivot table so please bare with me.

    I'm working on a spreadsheet that contains details of all the employees in an organisation similar to the attachment. There are some records that are missing their email, address etc. fields so I want to take that into record and display the total number of employees that are missing each field in a pivot table. I've tried and could count the employees that HAVE those fields (shown in the attachment) but how to you get the grand total of employees that DON'T HAVE those fields?

    I also want to know how to create a pivot chart to display the count but I don't know how to. Please help.

    Thank you.
    Attached Files Attached Files
    Last edited by pantaloc; 04-08-2016 at 12:15 AM.
    Reply With QuoteRegister To Reply
  2. 04-07-2016, 09:48 PM #2
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Pivot Table to count missing fields

    Hi,

    Everything I have read indicates that this can't be accomplished within a pivot table.
    The main workaround provided is using

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    at the bottom of your pivot table.

    You can use the same formula on the bottom of your data to accomplish the same thing.

    Hope it is helpful.
    Reply With QuoteRegister To Reply
  3. 04-07-2016, 10:05 PM #3
    pantaloc
    pantaloc is offline
    Registered User
    Join Date
    04-07-2016
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    5

    Re: Pivot Table to count missing fields

    Thank you southward for your quick reply. I have thought of what you suggested as an alternative way but I just want to know if it is possible to do it with a pivot table or not, so thank you for clarifying that for me.

    Hope you'll have a great day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculated Fields in a Pivot Table when 'Fields' appear over Muliple Lines
    By HangMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  2. [SOLVED] Pivot Table fields based on two counted fields
    By tejas.itraj in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-17-2014, 10:53 AM
  3. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  4. Grouping in Pivot Table with varying count of fields
    By Scotch_And_Dry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2009, 08:11 PM
  5. 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
  6. Differentiate between column fields and data fields in a pivot table
    By whiteheadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2009, 01:59 PM
  7. Pivot Chart fields missing in Excel 2007?
    By Richard Buttrey in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2008, 11:46 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1