| 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 |
| 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) | |||
Threaded Mode
