+ Reply to Thread
Results 1 to 2 of 2

A Percentage attendance number

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    Tampa, Florida
    MS-Off Ver
    MS Office 365
    Posts
    46

    A Percentage attendance number

    I am trying to calculate overall percentages in a Pivot table and not having much luck. In my attached fictitious workbook I have two tabs. The "raw data" tab contains names and whether they attended a Math-101 class. If *they did* attend the class then the date that they attended is entered for that student. If they did not attend then their cell is left blank. As you can see by my example, 4 people have attended.

    The Pivot table I'm building is in the tab labeled "Pivot." I dragged Name to Rows and Math-101 to Values. Notice the Grand Total is 4. That's great but what I really need is an additional column, (or something) that says 40%. I'm trying to convey information that shows this class had 40% attendance."Is there a way I can do this in the Pivot table itself and not by doing an external calculation? Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: A Percentage attendance number

    Perhaps this will be of some help although it differs from the original data set up and what was displayed in the pivot table.
    In the data set a third column is added that records whether the student is present or absent for the day. The second column is completely filled with the date.
    The pivot table summarizes the data instead of showing the individual students*.
    Field value for the present field is set to show values as % of row total.
    *To get a display of the students who are present, or absent, for a certain day double click on the desired cell. Sheet1 models the result of double clicking on the cell displaying the percentage of students that were present on 5/1/2019.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  2. Calculate percentage meeting attendance month by month over the year
    By Carol27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-20-2016, 02:57 AM
  3. Calculating percentage attendance from symbols
    By slinky_crazy in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-02-2014, 11:05 AM
  4. Attendance Percentage
    By vulcanrvn90 in forum Excel General
    Replies: 2
    Last Post: 02-03-2012, 02:00 PM
  5. Preparing Weekly attendance Percentage of Agents
    By luckyros in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-27-2008, 09:49 PM
  6. attendance percentage
    By megabytecomput in forum Excel General
    Replies: 1
    Last Post: 01-20-2008, 08:42 AM
  7. [SOLVED] Percentage of overall attendance
    By tannersnonni in forum Excel General
    Replies: 6
    Last Post: 05-13-2005, 01:06 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