View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Pivot table aging report sort order

We can extract numbers on an "aging data" tab, but a subsequent pivot
table has the days listed in columns in either one of the following
order:

Over 1 year 90 60 365 30 270 180

or

0-30 181-270 271-365 31-60 61-90 Over 1 year

Obviously, we'd prefer that they be in a more usable sequence of 0-30,
31-60, etc. . .

Field settings/advanced allows a possible sort (ascending, or
descending), but still will not sort properly.

Perhaps the format of the source data?
Ideas are appreciated.

Pierre