+ Reply to Thread
Results 1 to 4 of 4

record the total possible attendance against actual Attendance

  1. #1
    Forum Contributor
    Join Date
    03-30-2009
    Location
    dublin
    MS-Off Ver
    Excel 2007
    Posts
    104

    record the total possible attendance against actual Attendance

    Evening Gentlemen,

    i have just finsihed putting together a datasheet recording attendance on different courses across each month and different types of Course etc.

    i have then used a Pivot Table to group, and organise the data. it is working every well even though i say so myself.

    my problem is this.....how can i (if at all) get the pivot table to display the actual attendance against the maximum attendance, preferably as a percentage. i have not recorded the Maximum attendance anywhere yet.


    Thanks in Advance

    BR

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: record the total possible attendance against actual Attendance

    Hi BR,

    I saw MarvinP provide this link the other day which may help you.

    http://excel-diva.blogspot.com/2010/...fferences.html

    If not, please provide a sample workbook illustrating what you have and what you desire.
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    03-30-2009
    Location
    dublin
    MS-Off Ver
    Excel 2007
    Posts
    104

    Re: record the total possible attendance against actual Attendance

    the sheet shows the detail i have recorded.

    as you can see HRM course has three attendees......the capacity for this class is 6

    the mgt and training course both have two attendees and both have a capcaity of 4.

    i know i don.t have any of the capacities recorded, this is because i'm not sure which way to do it.


    i have considered creating a different sheet and building a formula to count each cousre and date and add the Capacity.

    is there a way of adding a column to the Attendance sheet and recording a value to use in the Pivot....this would be the handiest.

    at the end of the day....i am open to any suggestion
    Attached Files Attached Files

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: record the total possible attendance against actual Attendance

    I couldn't quite figure this out through a pivot table, but I'll keep trying.

    In the meantime, look at the attachment and see if this table in G1:J4 will help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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