Re: $$Excel-Macros$$ month wise seq in pivot

2013-08-02 Thread P.VIJAYKUMAR
Respected Hemal, You can also group dates in a pivot table.Please see the following links for a detailed example. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/ http://office.microsoft.com/en-in/excel-help/group-or-ungroup-data-in-a-pivottable-report-HA102840048.aspx http://www.you

Re: $$Excel-Macros$$ month wise seq in pivot

2013-08-01 Thread hemal shah
how to create custom list On Friday, 2 August 2013 11:03:32 UTC+5:30, vijay wrote: > > Respected Hemal, > > Create a custom List and sort moths according to that custom list. > > > Regards, > Vijaykumar > > > On Fri, Aug 2, 2013 at 10:33 AM, hemal shah > > wrote: > >> in this file, there is sheet

Re: $$Excel-Macros$$ month wise seq in pivot

2013-08-01 Thread P.VIJAYKUMAR
Respected Hemal, Create a custom List and sort moths according to that custom list. Regards, Vijaykumar On Fri, Aug 2, 2013 at 10:33 AM, hemal shah wrote: > in this file, there is sheet named "Sale Summary". > > In the column labels, I have put Year and below that i put month. > but the mont