date roblems in pivottable

[yves alexis]

hello,

i have a list of customers who bought items at specific dates (dd/mm/yy).
when i want to use the pivottable in order to see who bought what each
month, i cannot seem to have the date behave as (mm/yy).
how can i translate my dd/mm/yy into mm/yy ?

thanks in advance

yves

 

[Frank Kabel]

Hi
one way:
use a helper column in your source data. E.g. if your dates are in
column A use the following formula
=TEXT(A1,"mm/yy")
and copy down
use this helper column in your pivot table

 

[Hans]

hi

double click on the grey heading and select number. Then
choose the date format you want.

Hans

 

[yves alexis]

hello hans and frank,

thank you very much for the very fast reply

all the very best

yves

 

[Paul Falla]

Dear Yves

There are two ways of tackling this. The quick solution
would be to highlight and group each month's data in the
pivot table - I would only recommend this for a quick one-
off solution. If this type of report is something you are
likely to want to look at often, then I would add a new
field to your source data that looks at the Date field and
pulls out the year and month as a new result. Then use
this new field in place of the Date field in your pivot
table.

Hope this helps

Paul Falla

 

[Debra Dalgleish]

Right-click the Date field button.
Choose 'Group and Show Detail'>Group
In the list, choose Years and Months, click OK