Retaining the order of Data while using Pivot table
 

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

Retaining the order of Data while using Pivot table
 

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

Retaining the order of Data while using Pivot table
 

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/13299557...09d/ITOps.html

thanks
max

"ryguy7272" wrote:

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

Retaining the order of Data while using Pivot table
 

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

Retaining the order of Data while using Pivot table
 

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

"Herbert Seidenberg" wrote:

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

Retaining the order of Data while using Pivot table
 

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/13356183...38_Report.html


"Herbert Seidenberg" wrote:

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

Retaining the order of Data while using Pivot table
 

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

Retaining the order of Data while using Pivot table
 

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" wrote:

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

Retaining the order of Data while using Pivot table
 

Declined

Retaining the order of Data while using Pivot table
 

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

"Herbert Seidenberg" wrote:

Declined