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