Hi,

I know how to reposition aging categories within a pivot
by adding the following line:
ActiveSheet.PivotTables("PivotTable1").PivotFields
("Aging").PivotItems( _
"Overdue").Position = 1

But my concern is that the macro won't work if a specific
again categorie isn't available (no data in that
categorie). How can this be solved with a if..then
structure.

Thanks in advance,
Hans Weustink