You may need a 'helper column'. See this:
http://www.pcreview.co.uk/forums/thread-3802356.php


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"max" wrote:

I created Pivot table , the data source are values of 2 columns from another
sheet in teh same workbook.
the 2 columns are Group and Resource names

for the group i had ordered it this way just to show hierarchy

IT
-AA
- - AA1
- - AA2
-BB
- - BB2
- - BB3
etc

but in pivot table the data gets sorted. IF i want to retain teh same order
in the dropdown in pivot how can i be able to achieve this.
I am using Excel2007
Thanks- max