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