Retaining the order of Data while using Pivot table

[max]

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

 

[ryguy7272]

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


HTH,
Ryan---

 

[max]

Hi Ryan,
Thanks for the update, but i am still struggling
HAve placed my file over here, can you please do this for me
need it soon to submit. Or let me know the steps to do it

http://www.4shared.com/file/132995577/10a1a09d/ITOps.html

thanks
max

 

[Herbert Seidenberg]

Excel 2007
Workaround for:
Sort in data source order,
or how to keep field from being sorted alphabetically.
No code.
http://www.mediafire.com/file/o2zgmzt2mzy/09_16_09.xlsx

 

[max]

Hi,
Thanks a lot for the sheet. Appreciate your time.
Can i know how you did these steps.
Thanks
Maxim

 

[max]

Dear Herbert,
Please reply to mine.
I have put another sheet. Jsut lke the one you did for me like grp1 etc
can you please achieve that grouping for me based on these 3 columns
mentioned in the file.
I want the source data to be as it is in the other sheet
pls find the file here
http://www.4shared.com/file/133561838/302d2012/Week38_Report.html

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Sort fields by source
Needed PT Option:
Number of items to retain per field: None
http://www.mediafire.com/file/rj4tmmumzyz/09_16_09a.xlsx

 

[max]

Thanks a lot Herbert for your quick response. I do get your instructions but
when i do so it doesnt work right.
Donno where i am wrong.
CAn i hav your email id please
Thanks
maxim

 

[Herbert Seidenberg]

Declined

 

[max]

Dear Herbert,
Thanks for your inputs, I was able to achieve all as you did. I am trying
to learn now my only problem is
for every occurance of a row for a SMO id
i keep getting 2 rows extra one simply iwth the name of project , product
line and then next row i get Total for every row repeated again with the
"SMOid Total" .i dont need that , please let me know how to do it
Thanks
max