Grouping large amount of data by day-of-week

[Dan]

I have a table with three columns; Date, Type and Day. The Day column was set
up by creating it from the date column (Format!Number!Custom!DDDD). There is
three years of data amounting to 22690 records. The Type column is for five
types of vehicles; car, pickup, van, suv and motorcycle. I want to create a
summary pivot table showing all the types of vehicles stolen on each day of
the week. For example:

TYPE Mon Tue Wed Thu Fri Sat Sun
CAR
PICKUP
VAN
SUV
MOTORCYCLE

I'm looking to find how many cars were stolen on a Monday over the three
year period. Same for the other types and days.

Thanks, Dan

 

[Fred Smith]

I see two choices. Add a column to your data, or create a calculated field
in your pivot talbe. In either case, use the formula:

=text(a1,"ddd")

Regards
Fred

 

[Dan]

Thanks Fred. That did it!
Appreciate your help...

 

[Fred Smith]

Glad it worked. Thanks for the feedback.

Fred.

Thanks Fred. That did it!
Appreciate your help...