Count items by day
I have a list of data where I want to know, by day, how many time different
items occur.
I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.
1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet
I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.
|