+ Reply to Thread
Results 1 to 2 of 2

Help with Pivot splitting columns and not showing data

  1. #1
    Registered User
    Join Date
    05-16-2015
    Location
    Skopje, Macedonia
    MS-Off Ver
    Microsoft Office 2010
    Posts
    1

    Help with Pivot splitting columns and not showing data

    Hi guys I'm sorry if a similar thread to this one already exists, I couldn't find it so I started a new one. So, I've conducted a research and now I need to make a Pivot table to show general numbers of the participants in the research. I'm sorry it's in Macedonian but I'll tell you what the columns and rows are about. The rows are the Faculties my participants study at, and the top row of the columns are the year of study (1,2,3,4,5,6) and under them are the genders (male, female). I had very hard time figuring out how to make it look like this but I managed to do it at the end but the problem is it doesn't show the numbers. I need this table to show from which Faculty how many participants have participated in the study, organized by the year of study and number of males and females for each year. Can someone help me with this? I'm new with Excel and Pivot tables and I'm having a really hard time managing them Thank you!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    12-16-2014
    Location
    Amsterdam, Nederland
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Help with Pivot splitting columns and not showing data

    HI,

    Pull any of the fields in the values part of the pivot and use as function count.
    Bas

    Any reputation is appreciated.

+ 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. Splitting data by columns?
    By time for heroes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2014, 07:40 AM
  2. [SOLVED] Splitting Data Into Columns
    By Adam845 in forum Excel General
    Replies: 5
    Last Post: 10-04-2012, 07:00 PM
  3. Replies: 2
    Last Post: 12-25-2008, 08:13 PM
  4. splitting data into columns
    By seafarer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2008, 03:57 AM
  5. Splitting data into columns
    By Jamie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2005, 12:30 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