View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 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