View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Li Bill Li is offline
external usenet poster
 
Posts: 46
Default Problem with Pivot Table and Dates

Create one cloum and convert date to month. Or use formula
in pivot table.

-----Original Message-----
I have a table with dates and I'm trying to use a Pivot
Table to see the information by month but I can not the
get the information grouped by month and year. I'm

getting
the information by single date. What should I do to get
the information grouped by month and Year?

Help will be greatly appreciated!

Best regards.

Alberto.
.