Pivot Table

Posted on 2012-09-15
Last Modified: 2012-09-15
I have a CSV file with over 500 records. I want to pivot the data by tech and date resolved. The only problem is my date field has time also. Is there a way to pivot this so I can have the tech names which would be going down 1 column and the date going across 1 row and then I'd have the count of incidents for each tech by date? Unless someone else has a better way to sort this?  I need it to look something like this ...

         9/10/12  9/11/12  9/12/12  9/13/12  9/14/12
John      1            1            3             4              5

Joe        1            1            3             4              5

Jane      1            1            3             4              5
Question by:Edward Pamias
    LVL 24

    Accepted Solution

    you can set it up as you wish, then right click on the date portion of the pivot table.
    Select Group then you can select days only. This will group by days, and should then count correctly.
    LVL 14

    Author Comment

    by:Edward Pamias
    I've requested that this question be deleted for the following reason:

    I fixed it myself.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now