One way is to put an extra two columns in your data with year and month
Your can then group on months and columns.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Madhu" wrote:

Hi
i have excel for resource palnning columns as Name , Jan,Feb...Dec i need to
sum individual resource sum for a perticular month and grand total for a year
, i almost got the solutions except for individual sum for each resource is
not able to caliculate using pivot table.