sum for each month
When you are setting the Grouping.....
Hold down the [Ctrl] key while you select Months AND Years.
The pivot table will then group Months by Years.
Does that help?
***********
Regards,
Ron
XL2003, WinXP
" wrote:
Ron:
Thanks for your help! However, I do not want the months to be combined
if they belong to different years. How to prevent this?
Jorge
|