Re: $$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread ashish koul
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1) and fill it down then try to sort the columns of pivot table On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi wrote: > Dear Rakesh, > > please see attachment. > in case of place months in ascending order. you have to do it manually. > right cli

Re: $$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread Waseem Saifi
Dear Rakesh, please see attachment. in case of place months in ascending order. you have to do it manually. right click on any month and move it to left, right, to beginning or to end. Regards, Waseem Saifi On 7/11/13, Rakesh Kumar Sharma wrote: > Dear Experts, > > I have a query related to Pi