date roblems in pivottable

  • Thread starter Thread starter yves alexis
  • Start date Start date
Y

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
 
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
 
hi

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

Hans
 
hello hans and frank,

thank you very much for the very fast reply

all the very best

yves
 
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
 
Right-click the Date field button.
Choose 'Group and Show Detail'>Group
In the list, choose Years and Months, click OK
 
Back
Top