I have a pivot table, and within the row field, I would be able to write a macro to move a certain row to the bottom, regardless of the number of rows. Currently, if I move the row to the bottom while recording the macro, it will list the position number, such as

ActiveSheet.PivotTables("PivotTable2").PivotFields("Carrier").PivotItems( _
"Other").Position = 8

I found that I will not get the result I want unless there are exactly 8 items in the row section. Does anyone know if there is a way to make sure that it moves to the "Last" position?

Thanks