Grouping large amount of data by day-of-week

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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
 
Back
Top