Easy Count of Fields

**Moogleson** · 06-02-2011, 08:22 PM

Hi, I'm currently looking for some help with understanding or attempting to summarize this data.

I need to be able to break it down by Employee Name(sdadmin), date it was created(created), and obtain a count of how many ticket numbers(mainid) that were made on that day.

The stats that I need to track are how many times does the person, appear with a ticket attached. I also need to remove any duplicated entries and obtain a count of those.

This maybe a bit too much to have it easily done. I get this report weekly and want to summarize it quickly.

Any tips or help would be greatly appreciated.

**jeffreybrown** · 06-02-2011, 09:57 PM

If you want to summarize quicly look at a pivot table

http://www.pivot-table.com/

See attached

**Moogleson** · 06-03-2011, 06:56 AM

I reading over how to do this and this looks like the answer, my only question was how you were able to add the "Day" column.

Thanks Again

**jeffreybrown** · 06-03-2011, 09:03 AM

Take a look here for some reading on grouping.

http://www.contextures.com/xlPivot07.html

Basically you are going to click on the pivot table >> right click on the row labels and select group.

In the next dialogue box you should see months highlighted. Click on days and then with the ctrl button pressed click on hours or whatever fits your needs.