help needed in excel 2010 pivot chart
 

Hi Everybody,

I am using EXCEL 2010 in my system and I am working on some sales data. In view of the large data, I wanted to group my timelines with months instead of dates. So, I went into PIVOT TABLE TOOLS in the menu, selected OPTIONS to use the GROUP FIELD function, but the GROUP FIELD function is disabled in my Excel 2010. I am unable to activate/enable this GROUP FIELD function .

I would really appreciate if folks here can let me know on how to enable/activate the GROUP FIELD function.

Thanks and Cheers.

Hi,

One issue I can think of could be with the way your dates are formatted in source data. If any of the dates in the entire column is invalid (not a recognized format) than grouping is prohibited.
It is strange, though, that it is disabled. Even in the above explained scenario the option is still enabled but you receive an error message saying the grouping cannot be done.
Check if this is the root cause of your issue.

I hope it helps you.

Prashant