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