Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • Last Modified:

Pivot Table

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
0
Edward Pamias
Asked:
Edward Pamias
1 Solution
 
SteveCommented:
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.
0
 
Edward PamiasTeam Lead RRS DeskAuthor Commented:
I've requested that this question be deleted for the following reason:

I fixed it myself.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now