D Dee Member Dec 21, 2010 #1 Hi, The pivot table that i have created always sort either in ascending or descending order.i have to retain the same order that i have in my source data.Can anyone help me on this pls... Thanking you in advance, Dee...
Hi, The pivot table that i have created always sort either in ascending or descending order.i have to retain the same order that i have in my source data.Can anyone help me on this pls... Thanking you in advance, Dee...
Radu New Member Dec 21, 2010 #2 Hi, In Excel 2007, in Pivot Table options - Display Tab - Field List. You have there 2 options: "Sort A to Z" and "Sort in Data Source order". Hope this helps, Radu
Hi, In Excel 2007, in Pivot Table options - Display Tab - Field List. You have there 2 options: "Sort A to Z" and "Sort in Data Source order". Hope this helps, Radu
Hui Excel Ninja Staff member Dec 21, 2010 #3 Dee, You can manually click & drag field values also to rearrange to suit yourself
