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
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