+ Reply to Thread
Results 1 to 3 of 3

Point System Attendance - Pivot Table Assistance

  1. 11-03-2013, 03:46 AM #1
    nikakims is offline
    Registered User
    Join Date
    11-03-2013
    Location
    Kenya, Africa
    MS-Off Ver
    Excel 2010
    Posts
    1

    Point System Attendance - Pivot Table Assistance

    Hello,

    My company will be going to an 8 point attendance system come January 2014.

    I am trying to create an excel sheet that will facilitate this for me. My question is, how can I generate a report to see by employee the month the infraction took place?

    I saw something similar on a different excel sheet that reports codes versus points (see picture).

    Pivot Table.JPG

    I was unable to duplicate it since I am not familiar with pivot tables at all.

    Can someone assist me with this?

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-03-2013, 07:44 AM #2
    SDCh is offline
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Point System Attendance - Pivot Table Assistance

    See the attachment

    Note:
    If you want use Pivot Table, see this http://www.youtube.com/watch?v=ZBn1-r0I5oE
    (Press ALT+D+P for starting create Pivot Table from multiple tabs)
    Attached Files Attached Files
    Last edited by SDCh; 11-03-2013 at 08:05 AM. Reason: Add Note
    Click (*) if you received helpful response.

    Regards,
    David
    Reply With QuoteRegister To Reply
  3. 03-14-2014, 07:43 PM #3
    burgesc1 is offline
    Registered User
    Join Date
    03-14-2014
    Location
    New London, NC
    MS-Off Ver
    2010
    Posts
    1

    Re: Point System Attendance - Pivot Table Assistance

    Quote Originally Posted by nikakims View Post
    hello,

    my company will be going to an 8 point attendance system come january 2014.

    I am trying to create an excel sheet that will facilitate this for me. My question is, how can i generate a report to see by employee the month the infraction took place?

    I saw something similar on a different excel sheet that reports codes versus points (see picture).

    Attachment 275334

    i was unable to duplicate it since i am not familiar with pivot tables at all.

    Can someone assist me with this?

    Thank you
    thank you so much -
    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. Attendance Point System Spreadsheet with Rolling 1-year Points Reversal
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 04:46 PM
  2. [SOLVED] How can I create a point system for attendance, tardies, absents, etc.?
    By amytr1122 in forum Excel General
    Replies: 10
    Last Post: 07-20-2018, 09:55 PM
  3. Keeping track of attendance point system
    By okracerx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2013, 11:08 PM
  4. Pivot table assistance
    By tdevine in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-13-2013, 08:34 AM
  5. Need Pivot Table assistance
    By razor0323 in forum Excel General
    Replies: 1
    Last Post: 06-22-2011, 06:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1