Re: $$Excel-Macros$$ How To Add A Year Field to a PivotTable Field List

2011-10-03 Thread B.N.Chethan kumar
Hi, you have option to group the file...Bring the data in excel pivit..and right clickselect group...and select group by year.. you can also group my month Quarter too.. Regards Chethan Kumar BN On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith johnasmit...@gmail.comwrote: Attached is

Re: $$Excel-Macros$$ How To Add A Year Field to a PivotTable Field List

2011-10-03 Thread John A. Smith
Chethan, Thank you for your quick and enlightening response. This opens up new avenues for me. Thank you very much!!! John On Mon, Oct 3, 2011 at 4:26 PM, B.N.Chethan kumar chetankumar1...@gmail.com wrote: Hi, you have option to group the file...Bring the data in excel pivit..and

Re: $$Excel-Macros$$ How To Add A Year Field to a PivotTable Field List

2011-10-03 Thread NOORAIN ANSARI
Dear John, You can also try... Pivot Table Tools-Options-Group Selection... -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Oct 4, 2011 at