wow, it works ...

thanks for your prompt reply and happy new year!



"Andy Brown" wrote:

I would like to create a PivotTable to count the total sales of each
product
for each month. However, I am having problem to do the count by month.
Currently, I have to add another Month column

You don't need the extra column. Assuming you have Products down the side
(Row area), dates across the top (Column area) & Count of Product in the
middle (Data area):

Rightclick a Date cell across the top & choose "Group and Outline -- Group"
from the pop-up menu. If your data spans years, you'll need to group by
month *and* year.

HTH,
Andy