Group by month in a Pivot table
I have a sales report for the last two years that has three columns,
1)Customer (there are several entries per month for each customer)
2) Invoice Date
3) Amount.
I want to create a Pivot table that in column A lists each customer (only
once) and has 24 other columns Jan 2006 €“ Dec 2007 that sums the total sales
for each customer. When I set the pivot table up I get a column for each date
and have no idea how to group it by month.
Thanks in advance for any advice you can give!!
|