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

Pivot table aging report sort order
 

On Jul 9, 2:19 pm, Pierre wrote:
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
I figured it out.
Right-click on a cell that contains a pivot item column heading, lets
say 31-60.

From the shortcut menu, choose Order, then click on one of the Move
options (right or left), we can move the heading (and subsequently
it's filtered data, to a more readable cell.

Cool, thank you to Debra D's site.

Pierre