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

"Dan" wrote in message
...
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

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

"Fred Smith" wrote:

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" wrote in message
...
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

Glad it worked. Thanks for the feedback.

Fred.

"Dan" wrote in message
...
Thanks Fred. That did it!
Appreciate your help...

"Fred Smith" wrote:

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" wrote in message
...
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