+ Reply to Thread
Results 1 to 2 of 2

Pivot table problems

  1. #1
    Registered User
    Join Date
    02-07-2017
    Location
    Berlin, Germany
    MS-Off Ver
    2013
    Posts
    1

    Question Pivot table problems

    Hey guys! I have a very important and urgent question:

    I am doing a quantitive content analysis of newspaper articles and have coded them all in different categories. One of the categories would be "Gender of the victim". 1=female, 2=male, 3=both, 4=not specified, 5=not applicable. In one of the analysed newspapers, there was no article with female and male victims, hence "3" never appears in that column.
    I created a pivot table, to see how many articles fell into which category and to see each category's percentage of the grand total. However, because "3" never appeared in the column, it is not included in the pivot table rows, but I need it to be there, even if the amount of articles that apply to this category are 0.
    Do I have to add any info into my data matrix or do I have to manually add another row in the pivot table (and if yes, how on earth do I do that?)

    Thanks so much in advance for your help!!!
    Antonia

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table problems

    Hi,

    If 3 ever appeared in that field for that pivot table, you need only check the option to show items with no data. If it did not, you would have to add a row to your original data table with a 3 in it.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Need help with Pivot table problems
    By Ephy in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-02-2014, 07:25 PM
  2. [SOLVED] Problems with sorting andf Pivot Table problems
    By Saturn in forum Excel General
    Replies: 4
    Last Post: 10-07-2012, 07:47 AM
  3. Problems with Pivot table
    By Ozwilly in forum Excel General
    Replies: 7
    Last Post: 02-27-2012, 02:12 AM
  4. Pivot table problems
    By beloosesky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2010, 12:29 PM
  5. pivot table problems
    By CatherineC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2006, 07:10 PM
  6. [SOLVED] Pivot Table problems
    By Randy Starkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 10:25 PM
  7. Pivot Table Problems
    By Rachel Gonsior in forum Excel General
    Replies: 3
    Last Post: 03-21-2005, 04:06 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