• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inactivate automate sorting in Pivot table

Dee

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


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


You can manually click & drag field values also to rearrange to suit yourself
 
Back
Top