| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retaining the order of Data while using Pivot table
Declined
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining additional row info on refreshing data table | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
| Order Data in Pivot Table Non ascending or Decending | Excel Discussion (Misc queries) | |||
| pivot table in data source order | Excel Discussion (Misc queries) | |||
Hybrid Mode
