+ Reply to Thread
Results 1 to 4 of 4

How do I get data for the reason codes broken down by reason and time in a pivot table

  1. #1
    Registered User
    Join Date
    07-28-2015
    Location
    Chicago
    MS-Off Ver
    excel 2013
    Posts
    2

    How do I get data for the reason codes broken down by reason and time in a pivot table

    Attachment uploaded

    Pivot table broken down by date, reason, and time
    ex.
    Log On DateTime Log On Duration Reason Code Duration % Log On Duration %Not Ready
    7/1/2015 3:53 649:06:41 [0] 0:02:26 0.01% 0.16%
    Break[1] 0:20:03 0.05% 1.36%
    Cross Dept Work[5] 0:27:34 0.07% 1.87%
    Lunch[4] 0:30:34 0.08% 2.07%
    Meeting[2] 0:00:04 0.00% 0.00%
    7/2/2015 3:58 625:01:54 [0] 0:00:06 0.00% 0.01%
    Break[1] 0:24:30 0.07% 1.66%
    Lunch[4] 0:29:10 0.08% 1.97%
    Meeting[2] 0:50:52 0.14% 3.44%
    Attached Files Attached Files
    Last edited by bmccann; 07-28-2015 at 07:31 AM.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How do I get data for the reason codes broken down by reason and time in a pivot table

    I'm not sure exactly what you are after but I gave it a shot...

    what I did was fill in your data so you can pivot it. I'm sure if this a solution you can work with. I was then able to pivot by date (Rows), Reason (Columns) and count of reason (again not sure what you are looking for in the PT)...

    HTH....
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    07-28-2015
    Location
    Chicago
    MS-Off Ver
    excel 2013
    Posts
    2

    Re: How do I get data for the reason codes broken down by reason and time in a pivot table

    Thank you very much for the help, but I am unable to open the file - states file is corrupt

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How do I get data for the reason codes broken down by reason and time in a pivot table

    weird---I can open it just fine...

    here it is again....

    can anybody else jump in and try to open this file?
    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)

Similar Threads

  1. Countiffs gives for some reason #value
    By Megge001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2015, 02:43 PM
  2. run time error '91' -reason for error known, unsure how to fix it
    By xacx3x in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-11-2014, 11:19 AM
  3. [SOLVED] for some reason i cant filter
    By zazzz in forum Excel General
    Replies: 8
    Last Post: 05-29-2013, 02:27 PM
  4. Undo VBA code repeats only on table header for some reason. Can't figure out why.
    By drew.j.harrison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2013, 01:44 AM
  5. Replies: 5
    Last Post: 02-21-2013, 02:41 PM
  6. Column data shifts down for unknown reason
    By rerics in forum Excel General
    Replies: 1
    Last Post: 01-11-2012, 03:50 AM
  7. [SOLVED] Is there a reason for this:Read Only
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2005, 11:05 AM

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